You could check out DataValidation...List or check that
Toolsoptions...EditEnable autocomplete for cell values is checked

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Dmafk" wrote in message
...
I want to know how to automate drop down lists in excel, so that data entry
staff can type in the letter and the option appears, without necessarily
opening the drop down list.

I have seen spreadsheets designed in such a way that when staff place
their
cursor over the cell a little hand appears similar to either html or
access.

All help gratefully received.