Drop down menu-Can I insert a drop down menu in to an excel spreadsheet

Hi everybody,

Can I insert a drop down menu in to an excel spreadsheet into which I can type one or more letters and the menu will scroll down to that entry rather than having to scroll every time I wish to insert an item into a cell? The menu I have at the moment reverts back to the beginning for every entry, it's quite a long list, so a lot of scrolling!!
Your help will be appreciated as ever.
tia.
Dave.

Hello

I think below video will help u.

http://www.bestechvideos.com/2008/07...-vs-validation

Many thanks for your help.
I'll work on that.