If the item you want to delete is somewhere in the middle of your list, right.

How to add drop down list in excel data entry form. To extract the unique items, use this formula: Select a cell in which you want the dropdown to appear (d3 in our case). To remove an item, press delete.

Add the form tool to excel; You can add or delete items from your drop. Make sure the items are consecutive (no blank rows).

=unique (a2:a21) optionally, you can sort. This is useful when you need to enter a set list of employees, products, part. Web excel data entry form;

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