How can I get to data in drop down lists in Excel by pressing lett

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You could check out Data>Validation...>List or check that
Tools>options...>Edit>Enable autocomplete for cell values is checked

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top