To create a drop down list in excel, you just need a series of options to choose.

How to add extra drop down list in excel. In the source box, add new list. For the picklists to appear in multiple cells, you can simply copy them like any other cell content. Optionally, you can check the box to.

Web select a cell in which you want the dropdown to appear (d3 in our case). Web on the ribbon, click data > data validation. On the data tab, in the data tools group, click data validation.

In the dialog, set allow to. Select the data tools group from the data tab. On the second sheet, create the following named ranges.

The cleanest way to set something like this up is to create a new tab in excel where you can configure all of. Select the cells that you want to contain the lists. Web setting up the drop down list.

In the data validation dialog. =unique (a2:a21) optionally, you can sort. First, let’s start with the basics — creating the list.

Web you aim to add a dropdown list where each item appears just once. In the dialog, set allow to list. On the ribbon, click the data tab, and click data validation.