Microsoft Excel offers a very interesting way to clear dropdowns. 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 dropdown 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 – Dropdown cleared
– We can see that the dropdown has been cleared