Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 5
Default How do I delete list boxes from Excel spreadsheets?

I am trying to clean-up a spreadsheet with literally thousands of drop-down
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 35,218
Default 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   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 22,906
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how ro remove boxes in spreadsheets chusu New Users to Excel 3 September 26th 07 01:46 AM
way to delete the input area on several Excel spreadsheets MarcelMarceau Excel Worksheet Functions 2 August 2nd 07 08:10 PM
Selecting subsets using combo boxes or list boxes CLamar Excel Discussion (Misc queries) 0 June 1st 06 07:43 PM
Questions on combo boxes and list boxes. Marc New Users to Excel 1 March 14th 06 10:40 AM
How can I delete ALL text boxes in Excel worksheets? Genesis Excel Discussion (Misc queries) 3 January 20th 05 04:11 PM


All times are GMT +1. The time now is 11:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"