Data validation doesn't support autocomplete. 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


GBH99 wrote:
How do I get my dropdown (done with Data validation) to jump to the section,
I have around 2000 entries and I need it to work so that if I hit "S" it
jumps to the sections starting with that but if I type "sol" it will go to
entries starting with SOL.

Thanks


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