Use a combobox, it works that way.

--
HTH

Bob Phillips

""PA via OfficeKB.com"" wrote in message
...
I have a list of over a thousand names in a dropdown menu. I would like to
start typing a name in the cell (in the dropdown menu) and have excel
automatically recognize the name and go to that name in the dropdown menu
before I even finish typing the full name. How do I do this?

thanks.