View Single Post
  #3   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

To select all the objects on the sheet --
Choose EditGo To, click Special
Select Objects, click OK

Or, to work with specific objects, you can add the 'Select Multiple
Objects' tool to one of your toolbars:

Choose ToolsCustomize
Select the Commands tab
Select the Drawing Category
Drag the 'Select Multiple Objects' tool onto one of your toolbars
Click Close

Then, click the Select Multiple Objects button, and select any or all
objects on the worksheet.


pwermuth wrote:
How can I delete a lot of charts? Is there any way to select all
charts and then deselect the few I don't want to delete?

Or is the only option to delete not only the contents but the entire
cells (rows, columns,...) that the charts are based in?

Peter




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html