Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Advanced Data Validation
Dear all,
I wonder how can I type the first letter of a word in a cell which has data validation on a list of names. For example, the list of data is "Apple, Banana, Bicycle, Orange...". If I type "b" in the cell, the 1st word starting with "b" will appear i.e. Banana. Therefore I do not need to scroll the down the arrow to choose "Banana". Hope someone can give advice. Louis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation | Excel Worksheet Functions | |||
Data validation screen size | Excel Discussion (Misc queries) | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Automatic Data Validation drop down creation | Excel Discussion (Misc queries) |