Can drop-down menus in Excel include shortcuts to quickly find items?
Posted on 2011-09-17
Once a drop-down menu has been created (Data > Data Validation) in Excel (2010), is there a way to enable quick access to items in the list by entering the first letter, etc?
For example, suppose that your Data Validation source references the range $A$1:$A$1200 which contains 1000+ names. With that many items present in the drop-down menu, it can take quite a bit of time to scroll down to the desired item.
As a shortcut, some lists are designed so that entering a letter in the alphabet causes the list to "jump" to the section of items beginning with that letter. A familiar example of that is the Quick Access Toolbar (QAT) customization screen. If the setting to show All Commands is selected, the list includes over 1200 options. However, pressing the key for any letter instantly moves you to the corresponding section of the list.
Therefore, my question is whether or not that capability is available or possible in Excel drop-down menus.