How do I delete list boxes from Excel spreadsheets?
 

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

How do I delete list boxes from Excel spreadsheets?
 

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.



hardworker wrote:

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

--

Dave Peterson

How do I delete list boxes from Excel spreadsheets?
 

If the dropdowns are created using DataValidationList, these are not
considered objects.

Try EditGotoSpecialData ValidationOK

EditClear All


Gord Dibben MS Excel MVP

On Fri, 22 Aug 2008 10:34:43 -0500, Dave Peterson
wrote:

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.



hardworker wrote:

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