This recent thread may help
http://www.microsoft.com/office/comm...d-1500d2f1af63
--
If this helps, please remember to click yes.


"rakowd" wrote:

I'm using Excel 2007. I have a range of items that are set up as a list. In
the column where I select from the list my drop down box does not allow me to
put in a character such as "R" then go to that group of names. How do I set
this up so that I do not have to scroll down the complete list before getting
to the "R's". tx