Autocomplete

  • Thread starter Thread starter Alex Garner
  • Start date Start date
A

Alex Garner

Can auto-complete only be used in conjuntion with a combo-box? Or is there
another way?
 
Hi,

If you have a column of entries such as

Fred
Adams
Chen

and you type C in the next row below Excel begins an auto compete which you
can keep by pressing enter or continue typing if you don't want the item.
However this is not true autocomplete because if your list has two items
beginning with C is will not show you those two items. When you have typed
enough to uniquely idemtify the match then the item is displayed.

Technically AutoComplete works in Excel 2007 when you type = and then a
letter. But this is really Function AutoComplete.
 
If you are looking for autocomplete in a dropdown list then ComboBox is only
way.

DV dropdowns do not support autocomplete.

But autocomplete will work without any type of dropdown if the values lie in
a contiguous range above or below the entry point.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Excel 2007 Paste Values-Text Only (Always) 1
Excel How to Autocomplete text/string within a single cell, between different worksheets 1
AutoComplete for Cell Value 18
Autocomplete not working right 2
Auto fill not working 2
How can I enable auto complete? 2
MS Access problem 0
The next Grand Theft Auto title has been officially announced 0

Back
Top