Autocomplete dropdown

Copper Contributor

As far as I can tell Excel has no native capability to make a dropdown that dynamically narrows the list as you type. This would be very useful for data validation dropdowns with very long lists. Does anyone know of a way to do this, like a plugin?

2 Replies

@Faradn 

Microsoft is gradually rolling out this feature in Excel in Microsoft 365.

In other versions, you might use a combo box - see Data Validation Combo box 

@Faradn 

Try a free Excel add-in called "Search deList". It works on Excel 2007 or later. I just released a new version. You can find it here:
https://www.mrexcel.com/board/threads/i-created-an-excel-add-in-called-search-delist-to-create-searc...

search mode default.jpg