drop down list

F

free24

How do I enter values from a drop down list without using the mouse? I want
to enter a letter or number that corresponds to the first letter or number of
a cell in the validated drop down list, then select that entry without
clicking the mouse.
 
G

Gord Dibben

Data Validation dropdown box?

Autocomplete is not possible.

Using arrow keys to select the DV dropdown then hit Alt + Downarrow.

Using downarrow scroll to your choice and Enter to select.

To have Autocomplete you must use a combobox alone or in conjunction with
the DV dropdown.

See Debra Dalgleish's site for how-to.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP
 

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

dependent drop down list 1
Dependent drop down dynamic range formula, off sheet. 7
Selecting from a drop down list 2
How to use keyboard to enter the drop down list? 2
Formatted cell column in drop down list 1
Data Validation List (conditional) 2
Drop Down Starting Position 2
Data Validation drop-down width, with named range source (XL03 and 4

Top