Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
letter recognition in drop down lists
How do I get first letter recognition in a drop-down list without having to
use combo boxes? I have about 500 rows, and on each row a selection has to be made in a cell from a drop down list. Instead of having to scroll through the list, i would like to type in the first few letters of the data item and the list to recognise which item i'm trying to get... help please! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
letter recognition in drop down lists
You can get close to that. Sort your validation lists and at the beginning
of the A's enter a single A, do the same for the beginning of the B's and all the way through to the Z's. Click in the cell that has the drop down validation and type in the letter of the list you desire... say you type in an O. DO NOT hit enter... leave the cell in the edit mode (still selected) and now hit your down arrow. Should take you to the O which is the top of the O list of selections. HTH Regards, Howard "henben" wrote in message ... How do I get first letter recognition in a drop-down list without having to use combo boxes? I have about 500 rows, and on each row a selection has to be made in a cell from a drop down list. Instead of having to scroll through the list, i would like to type in the first few letters of the data item and the list to recognise which item i'm trying to get... help please! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down Lists: Allow option of adding own data if not in drop do | Excel Worksheet Functions | |||
How to create 2 dependent drop down lists from 1 original drop dow | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions |