drop down list

  • Thread starter Thread starter free24
  • Start date Start date
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.
 
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 dynamic range formula, off sheet. 7
Formatted cell column in drop down list 1
Created invoices in Excel - not working in Drive 1
How do I create a drop down box within a drop down box? 1
Data Validation drop-down width, with named range source (XL03 and 4
How to use keyboard to enter the drop down list? 2
Copy corresponding cell in Column B if cell in A contains certain text? 1
customize drop-down box 1

Back
Top