Create a Searchable Excel Drop-Down List with an Add-In
Question details
Create a searchable drop-down list that filters stock items as keywords are typed.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user needs to find an item quickly in a data-validation list containing hundreds or thousands of stock items.
- Observed behavior
- Typing keywords narrows the available choices so the user can select a matching stock item.
Place the stock items in a worksheet range and check that the target cells use Data Validation with the List option. Verify that the add-in supports your Excel version and that your organization permits add-ins.
Search a Validation List with the Search deList Add-In
Use an add-in to filter an existing Excel validation list without writing VBA.
Select the target cells, open Data > Data Validation, and choose List under Allow. Set Source to the range or named range containing your stock items, then select OK.
Obtain Search deList from its publisher and follow its installation instructions. If it is supplied as an Excel add-in file, use File > Options > Add-ins, choose Excel Add-ins under Manage, select Go, and browse to the file.
Select a cell that has list validation and press Alt+Right to open the add-in's searchable combo box.
Type one or more keywords, separating multiple keywords with spaces. Choose a matching item and press Enter to place it in the active cell.

Manage Stock Lists in WPS Spreadsheet
WPS Office is a free, lightweight Office alternative with a familiar interface for working with spreadsheets. Open compatible Excel files to move stock lists into WPS; Excel-specific add-ins and their searchable drop-down functionality are not guaranteed to work in WPS.

Frequently Asked Questions
How do I create the validation list before using the add-in?
Select the cells that need a drop-down, then go to Data > Data Validation. Choose List and enter the stock-item range or a named range in Source.
Can I search for more than one keyword?
Yes. In the Search deList search box, enter keywords separated by spaces to narrow the list, then select a result and press Enter.
Do I need to save the workbook as an XLSM file?
Not for the add-in method alone. If the workbook contains no macros of its own, it can remain an XLSX file.
Will the Excel add-in work in WPS Spreadsheet?
Do not assume it will. WPS can open compatible Excel spreadsheets, but support for Excel-specific add-ins and their searchable drop-down behavior may differ.




