Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
LostNFound
 
Posts: n/a
Default Cutting Drawing Objects

Is there a way to cut (Remove) multiple lines or objects at one time or must
you click on each one individually and cut. I use alot of lines and arrows on
spreadsheets in Excel but then need to remove them later and save the rest of
the data.
  #2   Report Post  
Mark Hone
 
Posts: n/a
Default

Hi LostNFound,

From the Drawing command bar, click on the Select Object button (looks like
a mouse pointer - white arrow). Now you can select (and delete) as many
objects as you like in one go. To return to normal cell selection, click the
same button again or double-click a cell that isn't near an object.

Cheers,

Mark


"LostNFound" wrote:

Is there a way to cut (Remove) multiple lines or objects at one time or must
you click on each one individually and cut. I use alot of lines and arrows on
spreadsheets in Excel but then need to remove them later and save the rest of
the data.

  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

And you can select (by clicking) the first and ctrl-clicking subsequent objects.

Then just one delete.

LostNFound wrote:

Is there a way to cut (Remove) multiple lines or objects at one time or must
you click on each one individually and cut. I use alot of lines and arrows on
spreadsheets in Excel but then need to remove them later and save the rest of
the data.


--

Dave Peterson
  #4   Report Post  
Michael
 
Posts: n/a
Default

Hi LostNFound. You can also press F5 (goto) click on special and check
objects. This will select all your objects at one time.
--
Sincerely, Michael Colvin


"LostNFound" wrote:

Is there a way to cut (Remove) multiple lines or objects at one time or must
you click on each one individually and cut. I use alot of lines and arrows on
spreadsheets in Excel but then need to remove them later and save the rest of
the data.

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 DO I KEEP DRAWING OBJECTS ANCHORED? HOW DO I KEEP DRAWING OBJECTS ANCHORED? Excel Discussion (Misc queries) 1 May 20th 05 01:35 PM
how can I select multiple drawing objects at once ExcelUser Excel Discussion (Misc queries) 1 February 11th 05 10:42 AM
How do I put drawing objects behind text/cells in a spreadsheet? Carl Excel Discussion (Misc queries) 1 January 19th 05 04:48 PM
"Drawing" Toolbar is inactive Deauxx Excel Discussion (Misc queries) 1 December 8th 04 03:03 PM
Vlookup / Objects help XL2003 Steve Jones Excel Discussion (Misc queries) 0 November 29th 04 05:01 PM


All times are GMT +1. The time now is 09:47 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"