Microsoft Excel offers a very interesting way to clear drop down. We can cater to this problem statement by using the “clear all” option in data validation. We can perform the below mentioned way to clear drop down in excel:
We’ll learn about this methodology step by step.
To do this yourself, please follow the steps described below;
Step 1 – Excel sheet with a drop down
– Open the desired Excel workbook containing a drop down
Step 2 – Go to data validation
– Now in the data option in the menu bar go to data validation option as shown in the image above
Step 3 – Clear all option
– Now in the data validation dialogue box click on the “Clear All” option and then click “OK”.
Step 4 – Drop down cleared
– We can see that the drop down has been cleared