On the first sheet, select cell b1.

How to add drop down list in excel step by step. To remove an item, press delete. Web excel is a fantastic tool for working with extensive data and user inputs. To extract the unique items, use this formula:

If the item you want to delete is somewhere in the middle of your list, right. Click on data validation (“data” → “data tools” → “data. Web you aim to add a dropdown list where each item appears just once.

Web go to the settings tab in the data validation dialog box. Choose the settings tab in the. Select the source button to minimize the data.

On the second sheet, create the following named ranges. As you can see in our simple example, we have created. Create a list of options make a vertical list of options you want users to be able to choose from.

Web to add an item, go to the end of the list and type the new item. =unique (a2:a21) optionally, you can sort. Web select the cell where you want the list.

Select the data tools group from the data tab.