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.

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

--
Regards,

Peo Sjoblom

(No private emails please)


"B9" wrote in message
...
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.

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

B9 wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html