Data Validation list selection question

B

Bob Wall

I have a cell with 352 entries for a user to choose (data validation list).

Is it possible to have the user type the first letter to speed up the
selection
process, that is, type "L" and the list will jump to the first entry
beginning with "L" rather than scrolling the entire list with the mouse?

As always, thanks in advance.

BW
 
D

Dave Peterson

Not using data|Validation, but maybe you could use a combobox from the control
toolbox toolbar???
 
J

Jason Morin

You can copy the range that that is the source for the
validation list either directly below or above the
validation cell. Also make sure AutoComplete is enabled
under Tools > Options > Edit tab > "Enable AutoComplete
for cell values.

You can then hide the cells with a custom format of ;;; .

HTH
Jason
Atlanta, GA
 

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

Select Drop-Down list entry by typing 0
Validate data but then change the entry to upper case 4
drop down list 3
Data Validation List (conditional) 2
COUNTIF and Data Validation 0
Data Validation - Custom question (multiple conditions) 8
Using Data Validation via an array to stop manual entries - possib 4
DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING 1

Top