Web you aim to add a dropdown list where each item appears just once.

How to add item to drop down list in excel. In the data validation dialog. When you select the drop. Let's say that the cell.

Combo box if you want your users to be able to type their own list entry or choose a value from a predefined list, use a combo. On the data tab, in the data tools group, click data validation. Web to insert a drop down list in excel, you use the data validation feature.

Enter a name, for example choices, and press enter. Web click the data tab. Web select a cell in which you want the dropdown to appear (d3 in our case).

In the resulting dialog, choose list. Make sure the items are consecutive (no blank rows). To extract the unique items, use this formula:

=unique (a2:a21) optionally, you can sort. In the new window, select “place in the document”, click on “worksheet_link” and press “ok”. In the data validation dialogue.

In the data tools group, click the data validation option. Click the data tab and then click data validation in the data. On the second sheet, create the following named ranges.