You can do this with programming, as explained he

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

Candyman wrote:
I would like to be able to type the first few letters in a cell that uses a
long drop down list and quickly go to the full name in the list without
having to start at the top of the list and scrolling down every time.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html