Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I KEEP DRAWING OBJECTS ANCHORED? | Excel Discussion (Misc queries) | |||
how can I select multiple drawing objects at once | Excel Discussion (Misc queries) | |||
How do I put drawing objects behind text/cells in a spreadsheet? | Excel Discussion (Misc queries) | |||
"Drawing" Toolbar is inactive | Excel Discussion (Misc queries) | |||
Vlookup / Objects help XL2003 | Excel Discussion (Misc queries) |