H hardworker Aug 22, 2008 #1 I am trying to clean-up a spreadsheet with literally thousands of drop-down
D Dave Peterson Aug 22, 2008 #2 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.
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.
G Gord Dibben Aug 22, 2008 #3 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
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