I have used Validation to create a drop down list in Excel, so far so good.
My question is - currently users have to click on the drop down and select an item from the list using their mouse or type in the word exactly as it appears in the list.
In Access, when you have drop down lists, you can start typing letters and it will come up with suggestions based on the letters you’ve typed. Is it possible to have a similar thing in my Excel worksheet?
The reason I ask is that I have about 15 columns of drop down lists, with about 300 rows of information to be completed. That’s quite mouse intensive for a user to complete.
Thanks in advance for any suggestions!