Autocomplete with Excel with any data in the same column
Solution 1:
Short answer, you cannot. Excel does not offer that. You need to have content in between in order for this to work. You can of course put a space or even a ` in that empty cell to fill it with content for this to work though, optionally colouring it white.