How To Remove Drop Down List In Excel
By
SpreadCheaters
Page last updated:
08/10/2022 |
Next review date:
08/10/2024
If you no longer need the drop down list, you can remove it.
Step 1 – Highlight the cells and click on Data and Validation under the Data tab.
As an example, data validation has been applied on column B, where a drop down list is sticking out on Cell B2.
Step 2 – Click Clear All
Clear All means that the drop down list will be removed on all the selected cells.
Step 3 – Click OK
Clicking OK will apply the action.
