You could use a combo box instead of data validation for your dropdown. The
combo box supports AutoComplete. Also, you can make the font bigger, etc.
Debra Dalgleish has complete instructions and a sample file on her excellent
Contextures site:

http://www.contextures.com/xlDataVal10.html

Hope this helps,

Hutch

"Ryan" wrote:

I have a list of 1000s of items and i want the same formula that was used to
make the formula autocomplete. I want to start typing and a list drops down
of all the avaliable options. Like if in my list is apple and appricot i
want to type a and both of them appear in a list. It is for my squadron
commander and i cant figure it out. Any help is much appreciated.