How to Quickly Remove Items from a Drop-Down List
Follow these steps to quickly remove items from a drop-down list-
Step 1: Right Click on the Cell, and Select delete the desired item from the cell range
In the cell range, simply click on the item you want to remove and right-click to delete.
delete
Step 2: Select the Shift cells up from the Options
In the dialog box that opens, click on the shift cells up option and press ok.
shift cells up
You will see that the item is deleted from the cell range as well as from the drop-down.
item deleted
How to Edit, Copy and Delete Drop Down List in Excel
A drop-down list allows us to make our Excel sheet more dynamic and intelligent by allowing the users to choose from a list of predefined options. Not only does this make data entry fast but it also helps in restricting the data that can be added to some cells.
Naturally, once you have created a drop-down list, you might also need to edit, copy, or delete it at some point in time. And this is exactly what we are going to learn about in this article. So let us look at the different ways in which you can edit, copy, and delete a drop-down list in Excel but first, check out how to create a dropdown in Excel if you don’t already know.
Contact Us