Hello I currently have a drop down menu with a long list of values to choose from. (I set it up in the data then validity menu) I would like to be able to start typing in the drop down menu to filter through the values (Example: Start typing p so only values start with p appear, type pl and only values that begin with pl appear etc etc)
As of right now it is only possible to scroll throug hand click on one.
Any help would be appreciated thank you