If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I delete list boxes from Excel spreadsheets?
I am trying to clean-up a spreadsheet with literally thousands of drop-down
|
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|