How do I delete list boxes from Excel spreadsheets?

  • Thread starter Thread starter hardworker
  • Start date Start date
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.
 
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
 
Back
Top