Select the data tools group from the data tab.

How to add options in drop down list in excel. Web i have a table that contains staff names and days of month. 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 select the cells where you want to add the dropdown.

Enter a name, for example choices, and press enter. To extract the unique items, use this formula: Web select the cell where you want the list.

Select cell b3 to make it the active cell. This will select the cell. =unique (a2:a21) optionally, you can sort.

Let's say that the cell. Then, go to the data tab and click “data validation” in the data tools section of the ribbon. Select data validation to open the data validation dialog box.

In the source box, enter the formula that indirectly refers to table1's column named items. Web you aim to add a dropdown list where each item appears just once. All you need to do is change how the data is added to the cell from typing in text to selecting from your list.

Click data validation under the data tools section of the data tab.