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.