Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel drop down box
I have a drop down box in my file I use to look up
customers, I would like to know how and if I can use the keyboard to jump to the customer by typing the frist letters of their name, a |
#2
|
|||
|
|||
If this is a data validation dropdown, it doesn't support autocomplete.
If you can use programming, there are instructions here for adding a combobox from which you can select one of the values from the data validation list. In the combobox, you can enable autocomplete: http://www.contextures.com/xlDataVal11.html nprice wrote: I have a drop down box in my file I use to look up customers, I would like to know how and if I can use the keyboard to jump to the customer by typing the frist letters of their name, a -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Is there a way to make a drop down list in Excel that lets you se. | Excel Worksheet Functions | |||
How do you create dual drop down menus in excel 2000? | Excel Discussion (Misc queries) | |||
Make copy from any document into Excel a right click with a drop . | Excel Worksheet Functions |