If this is a data validation dropdown, 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


68magnolia71 wrote:
Hello every one,

I use quite a lot of drop down lists in a work book and some of them are
pretty long. The question is: is there a way to pouch in the first letter of
a word ( the list is arranged in alphabetical order) so as the list goes to
that postion?
Thank you for any suggestion.

68magnolia71


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