Delete drop down list

Copper Contributor

How do I delete a drop down list in Excel?  I am working in Excel 2016

1 Reply

@ondylvnv 

 

How do I delete a drop down list in Excel?

 

Assuming you mean to deactivate the Data Validation, which is more technically what the drop down lists are.

Click on the range of cells (or cell) that contain(s) the drop down, and then in the Data Validation menu itself...

mathetes_0-1699913172112.png

...select Data Validation

mathetes_1-1699913225501.png

...and then click on the "Clear All" button in the lower left