How to remove drop down lists in Excel
By
SpreadCheaters
Sometimes we need to remove the drop down lists from our data sets. In this tutorial we’ll learn how to remove the drop down list from single or multiple cells. Let’s consider this example data set which has two drop down lists as shown above.
Drop down lists in Excel provide a very simple way to select a particular value easily from a list of items. These drop down lists are useful especially when we are dealing with large data sets.
Step 1 – Locate the data validation section in data tools group
– Select the cell from which you wish to remove the drop down list.
– Locate the Data tab and go to Data Validation section and click on it as shown in the picture above.
Step 2 – Remove the drop down list from one cell
– When you click on the data validation button a new dialog box will appear.
– In that dialog box go to the bottom left corner of the dialog box and locate the clear all button.
– When you will press the button the drop down list will be removed from that cell as shown in the picture above.
Step 3 – Remove the drop down lists from multiple cells
– To remove drop down lists from multiple cells together select them all by holding the CTRL button and clicking with the left mouse button.
– Now repeat Step 1 and then click on the data validation button again to open up a new dialog box.
– In that dialog box go to the bottom left corner of the dialog box and locate the clear all button.
– When you will press the button the drop down list will be removed from that cell as shown in the picture above.
So this is the method to remove the drop down lists from single and multiple cells in Excel.
