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

D

Dmafk

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.
 
N

Nick Hodge

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Filtered drop down list 2
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
Excel 2003: Help with Drop Down List 2
How do I designate dates using info from a cooresponding drop down list? 3
Data Entry In Column 1 with Drop-Down List 4
how do I set a drop down list to scroll to a letter by typing it? 1

Top