If there is method for allowing to auto complete when typing the first letter in the drop down list, everything will become easier. If you have a data validation drop down list with large items, you need to scroll up and down in the list just for finding the proper one, or type the whole word into the list box directly. How to autocomplete when typing in Excel drop down list?
