Web this is the most flexible method for adding list items in a dropdown list.

How to add drop down list option in excel. On the ribbon, click the data tab, and click data validation. In the data validation dialogue. Select the cells that you want to contain the lists.

In the dialog, set allow to. The list is in b3:b6 and the. 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.

A list of values and a blank cell to use as the data entry cell. Click data validation under the data tools section of the data tab. To extract the unique items, use this formula:

Then, customize the list using the data validation options. In an adjacent cell, insert a. Web you aim to add a dropdown list where each item appears just once.

=unique (a2:a21) optionally, you can sort. Select the cells where you want to add the dropdown.