Hello Friends,

I have created a sheet, which contains names of customers in alphabetical order and the customer just chooses his name from the list and all his data his shown. The problem is there are over 100 curtomers and scrolling through names is time consuming and customers dont favor it. Is there a way in data validation list which can allow me to navigate the drop down list faster by pressing the first letter or even typing a name and excel can auto-fill it based on the list.

Please let me know. Thanks for your time.

Best,
Jayant !