In the dialog, set allow to.

How to create a drop down list in excel that is searchable. On the second sheet, create the following named ranges. Web introduction 🔎 how to create searchable drop down list in excel kevin stratvert 1.87m subscribers subscribe 3.1k share 188k views 1 year ago how to use excel in this step. Web 0:00 / 10:59 searchable data validation in excel without vba searchable drop down list in excel (very easy with filter function) leila gharani 2.16m.

Choose the name of the formula you just created. Web enter =age in the “source” box (if you named your cell range something else, replace “age” with that name). If you can’t click data validation , the worksheet might be protected or shared.

On the first sheet, select cell b1. Unlock specific areas of a. On the ribbon, click the data tab, and click data validation.

Select the first cell below the “appetizer” heading ( cell b2 ). Select the cells that you want to contain the lists. Web press the menu button in the list search window to see the options.