Autocomplete over blank row

[sir_smee]

Hey, I have a sheet with a blank row between entries, but many of the entries are the same (Customer/Destination/etc). I would like these entries to autocomplete as if they weren't separated.

eg. Entry1 | Entry2
|
Entry3 | Entry2

Where "Entry2" should autocomplete, ignoring empty cell(s) between.

 

[jbeaucaire]

1) don't use blank rows (it inhibits autocomplete)
2) Put a space character into the empty cell so it isn't really blank.

 

[sir_smee]

Thank you, but that much I do know. I'm looking for way not to have to do that.

 

[jbeaucaire]

I figured you did know that, and thought telling you what you already know would verify that these are your options.

You have to change one requirement or the other. Autocomplete doesn't work across truly blank rows.

 

[sir_smee]

Kewl, thanks. Then I've gotta start a new question.