How do I get first letter recognition in a drop-down list without having to
use combo boxes?

I have about 500 rows, and on each row a selection has to be made in a cell
from a drop down list. Instead of having to scroll through the list, i would
like to type in the first few letters of the data item and the list to
recognise which item i'm trying to get...

help please!