Auto fill from drop down list as user types

Copper Contributor

I have a drop down list on one sheet that is populated by a list on another sheet using the Data > Data Validation feature (settings: Allow: List, Ignore blank, In-cell dropdown, Sourse: ='Drop Downs List'!$A$2:$A$1399). The problem is that the user has to scroll down through 1397 rows of department options. How do I add an auto fill feature that will start to complete the cell or at least narrow down the list as the user types in the text. Do I have to use VB script or is there an easier way to do this?

1 Reply

@dmbeach24 

Data Validation does not provide AutoComplete - you'd need to use a combo box plus VBA code.

See Data Validation Combo box Click (Excel for Windows only, not on Mac, Android, iOS or on the web)