How can I enable auto complete?

[ValHearon]

I have the auto complete option checked, however, if there are blank cells
above the cell I want to auto complete, it will not recognize any entries
above. Can excel autocomplete from more than the choices directly above it?

 

[Billy Liddel]

You might be able to use Excel's Autocorrect. Choose Tools, Autocorrect

e.g. Replace vh, Replace With:= Val Hearon

would this be suitable?

Peter

 

[Gord Dibben]

Excel will also autocomplete from contiguous cells below the insertion point.

Note the word "contiguous"..................above or below.


Gord Dibben MS Excel MVP