200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I can create dropdown lists with Data Validation in Excel for Mac 2011 and it seems generally fine, but I have to scroll through the entire list to get down to the place where the words begin with, for example. "Pe ...".
I would expect that Excel immediately jump to the first of the letters I enter.
One of my lists has 538 entries (record companies).
Hi and welcome to the forum!
Here is a great tutorial with lots of information on how to do what you want.
Data Validation Dropdown Combo Box
This tutorial makes it so the cell with the drop down menu automatically opens up a combobox when you double-click it and you should be able to use that combobox to get the results that you want.
I know I am supposed to post the basic information here in case that link fails in the future but there are just waaaaay too many steps involved. Essentially, you do what Variatus says, but you add a few more steps to make it a bit more user-friendly. Also, the macro they use to make the combobox's appear is quite cool!
Use an ActiveX combo box instead of the data validation.
