Nov 17 2022 09:39 AM
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?
Nov 17 2022 12:12 PM
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
Nov 17 2022 10:14 PM
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...