I have an online store with about 20,000 items and for typing consistency I utilize Drop down Lists for my categories, etc ... However, it would help me a LOT if I could avert having to scroll all the way down to my choice or take a chance and miss spell it. For Example. Lets say I want to select PEANUT from my list.

I would LOVE it if I could simply start typing Pea ... and all of a sudden the rest of the word would begin to show up as Im typing it. (auto suggest??) Im not sure what you would call it, till I would finally have the word Im looking for.

By just typing the first letter P, it would get me down the list all the way to the P's! rather than have to scroll down that far!! ..

A) does Excel 2007 offer such a feature/ability?
B) if so, - HOW?

signed -
One quickly balding! hehe
Thanks