Is there a way, in Excel 2007, to make it where you create a named list, and then make a validation table with a drop down menu which refers to that list that (the main point) you can hit a letter and it'll jump to that spot in the drop down menu?
An example would be, if you have a list of the months of the year, I can make it where if I type 'N' it will auto-complete November, but if I type 'J' and click the drop down arrow, it gives an error. If I type 'Ja' it will auto-complete January, but the drop down arrow will still give an error.
I know auto-complete works on the string of letters and fills in when you get a unique string, but I just want to be able to type a letter or two in the field, and then hit the drop down arrow and have it jump to the first word starting with that letter.
For instance, if I type 'Ju' in the field, I want the drop down menu to start at 'June' where if I need I can select June or July. (or anything else if I scroll.)
Question
Buttus
Is there a way, in Excel 2007, to make it where you create a named list, and then make a validation table with a drop down menu which refers to that list that (the main point) you can hit a letter and it'll jump to that spot in the drop down menu?
An example would be, if you have a list of the months of the year, I can make it where if I type 'N' it will auto-complete November, but if I type 'J' and click the drop down arrow, it gives an error. If I type 'Ja' it will auto-complete January, but the drop down arrow will still give an error.
I know auto-complete works on the string of letters and fills in when you get a unique string, but I just want to be able to type a letter or two in the field, and then hit the drop down arrow and have it jump to the first word starting with that letter.
For instance, if I type 'Ju' in the field, I want the drop down menu to start at 'June' where if I need I can select June or July. (or anything else if I scroll.)
Is that possible? It's driving me bonkers.
Thanks!
Link to comment
Share on other sites
2 answers to this question
Recommended Posts