| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using a drop down list -- Autojump to first letter
I have a spreadsheet with many many drop-down lists. Is there any way for a user to enter the first letter of an option and automatically jump to that option in the list? The goal is to make this faster to use than (or at least as fast as) writing it out, and right now, clicking on, scrolling through, and selecting from each drop-down is a lengthy process. -- Siobhank ------------------------------------------------------------------------ Siobhank's Profile: http://www.excelforum.com/member.php...o&userid=26133 View this thread: http://www.excelforum.com/showthread...hreadid=394611 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text to Columns from drop down list update | Excel Discussion (Misc queries) | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
| Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
| automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
| Drop List Referencing | Excel Worksheet Functions | |||
Threaded Mode
