How can I enable auto complete?

  • Thread starter Thread starter ValHearon
  • Start date Start date
V

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?
 
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
 
Excel will also autocomplete from contiguous cells below the insertion point.

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enabling Auto-Complete on several worksheets? 3
auto complete not working 3
Conditional formatting causing auto complete to deactivate? 3
The next Grand Theft Auto title has been officially announced 0
Excel How to Autocomplete text/string within a single cell, between different worksheets 1
Auto Complete Problem for 2007 1
Can you add data into the auto-complete list? 2
Auto-prompt/complete (?) function for number values 1

Back
Top