Good morning excel experts (my time). Just wondering aloud: I know how to create a searchable drop down list in excel. See the attached sheet. A small issue is that you have to type at least the first letter of the name you are looking for, and then press the arrow of the drop down list for names with the letter that you have typed to appear in the drop down list.
Question: is there a way to create a drop down list which pops up when I type the letter of the name I am looking for? In which case I will not need to press the drop down arrow? I hope my problem is clear. Thanks in advance for your help
Question: is there a way to create a drop down list which pops up when I type the letter of the name I am looking for? In which case I will not need to press the drop down arrow? I hope my problem is clear. Thanks in advance for your help
