Excel 2007 : Reducing drop list items as you type (how to set this up)

[Liz Lamach]

I know how to make a drop down list. I have over 100 items in my drop down list. How do I get it to allow me to type in the name and have it go to area in my drop down list that is closest to what I am typing. So, If my drop down list was the alphabet and I wanted to select "w", rather than scroll the list each time, I want to type w and have it go to the W's

[protonLeah]

Look at ActiveX comboboxes