Forum Discussion
Searchable Dropdown Lists on Multiple Rows
Try a free Excel add-in called “Search deList”.
It works like this:
In any cell that has data validation (with List type) pressing ALT+RIGHT will open a searchable combobox.
Type some keywords to search, separated by a space, e.g "ma la"
The list will be narrowed down as you type.
Hit ENTER to sent the value to active cell.
You don't need VBA, so you can save your workbook as .xlsx.
You can find it here:
https://www.mrexcel.com/board/threads/i-created-an-excel-add-in-called-search-delist-to-create-searchable-data-validation.1189466/
Try a free Excel add-in called “Search deList”.
It works like this:
In any cell that has data validation (with List type) pressing ALT+RIGHT will open a searchable combobox.
Type some keywords to search, separated by a space, e.g "ma la"
The list will be narrowed down as you type.
Hit ENTER to sent the value to active cell.
You don't need VBA, so you can save your workbook as .xlsx.
You can find it here:
https://www.mrexcel.com/board/threads/i-created-an-excel-add-in-called-search-delist-to-create-searchable-data-validation.1189466/
