Select the data tools group from the data tab.

How to add drop down list option in excel. Web you aim to add a dropdown list where each item appears just once. Web to add an item, go to the last row in the column, press enter or return, enter the new list item, and press enter or return again. Web this is the most flexible method for adding list items in a dropdown list.

Select the cells where you want to add the dropdown. A list of values and a blank cell to use as the data entry cell. In an adjacent cell, insert a.

To extract the unique items, use this formula: All you need to do is change how the data is added to the cell from typing in text to selecting from your list. In the data validation dialogue.

Then, customize the list using the data validation options. =unique (a2:a21) optionally, you can sort. On the ribbon, click the data tab, and click data validation.

Start by adding a table containing your dropdown list of items. Click data validation under the data tools section of the data tab.