Web select a cell in which you want the dropdown to appear (d3 in our case).

How to add list in drop down list in excel. Web select this range, then click in the name box on the left hand side of the formula bar. Select the cells that you want to contain the lists. On the ribbon, click the data tab, and click data validation.

To extract the unique items, use this formula: Highlight the cells that you want the list to be available in. Go to the data tab and click on.

The names for each group should match the list. The steps slightly vary depending on whether the source items are in a regular range,. =unique (a2:a21) optionally, you can sort.

Let's say that the cell. Create and test a data validation rule to provide a dropdown list for category using the following custom formula: Web with the two named formulas in place, you set up data validation in the usual way ( data tab > data validation ).

Select the data tools group from the data tab. In the dialog, set allow to. Web add an item to a cell range to add a list item, simply enter it below the existing items.

Just to be clear, the named range category. I usually like to put this on a separate sheet labeled data or something similar. Web how to create a dropdown list there are several ways to populate list items when you create a dropdown list within your spreadsheet.