How do I delete list boxes from Excel spreadsheets?


Ad

Advertisements

D

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.
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top