press letter and go 2 entry begin w letter in data validation drop

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

Guest

How can I get Excel's data validation dropdown to act list a regular listbox
dropdown, i.e., when I press a letter, the first item that begins with that
letter is highlighted in the list?

Thanks
 
Data Validation drop down lists don't support that.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You must log in or register to reply here.

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

xl2007 data validation drop-down box 1
Data Validation 1
Excel 2003 - Typing Letter in Dropdown Cell 1
Data Validation drop down list query 3
counting the first letters or first 2 letters in strings 1
Blank cell w/data validation & automatic fill in? 1
Drop-Down List Search Capability 1
Letter recognition in a Validated drop-down 4

Back
Top