drop down list in Excel

B

B9

I set up a drop down list in excel and wanted to know if there was a way to
set up a predictive text feature so that i don't have to scroll through the
entire list to select the correct entry. i would like to be able to type in
the first two letters and have the entry appear.
 
P

Peo Sjoblom

If you use the data>validation it is not built in, you need a combobox from
the control toolbox

--
Regards,

Peo Sjoblom

(No private emails please)
 
D

Debra Dalgleish

As Peo said, if you created the dropdown lists by using data validation,
it doesn't support autocomplete.

If you can use programming, there are instructions here for adding a
combobox from which you can select one of the values from the data
validation list. In the combobox, you can enable autocomplete:

http://www.contextures.com/xlDataVal11.html
 
Top