How to Remove the Drop-Down Menu from Selected Cells
Step 1: Select the cells with the desired drop-down
Select the cell/cells from where you wish to remove the drop-down.
Step 2: Choose data validation
Go over to the data tab and select the ‘Data Validation’ option from the data tools tab.
Step 3: Clear All
In the dialog box that opens, select the ‘Clear All’ button and click ok.
Note that the drop-down will be removed but the selected value still remains in the cells. You can simply delete them like you normally would using the delete key.
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