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

How to add drop down list in excel step by step. Web go to the settings tab in the data validation dialog box. When working with user inputs, it is a frequent scenario that the users are needed to choose. If the item you want to delete is somewhere in the middle of your list, right.

As you can see in our simple example, we have created. Web to add an item, go to the end of the list and type the new item. Then, go to the data tab and click “data validation” in the data tools section of the ribbon.

=unique (a2:a21) optionally, you can sort. Select the data tools group from the data tab. To remove an item, press delete.

Web excel is a fantastic tool for working with extensive data and user inputs. Create a list of options make a vertical list of options you want users to be able to choose from. Click on data validation (“data” → “data tools” → “data.

Select the source button to minimize the data. On the second sheet, create the following named ranges. On the first sheet, select cell b1.

To extract the unique items, use this formula: