How do I delete list boxes from Excel spreadsheets?

[hardworker]

I am trying to clean-up a spreadsheet with literally thousands of drop-down

 

[Dave Peterson]

Are there any shapes on that worksheet that you want to keep?

If yes, then don't do this!

Edit|Goto (or hit ctrl-g or F5)
Special
select Objects
Ok

Then hit the delete key.

 

[Gord Dibben]

If the dropdowns are created using Data>Validation>List, these are not
considered objects.

Try Edit>Goto>Special>Data Validation>OK

Edit>Clear All


Gord Dibben MS Excel MVP