| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I delete list boxes from Excel spreadsheets?
I am trying to clean-up a spreadsheet with literally thousands of drop-down
|
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how ro remove boxes in spreadsheets | New Users to Excel | |||
| way to delete the input area on several Excel spreadsheets | Excel Worksheet Functions | |||
| Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
| Questions on combo boxes and list boxes. | New Users to Excel | |||
| How can I delete ALL text boxes in Excel worksheets? | Excel Discussion (Misc queries) | |||
Linear Mode
