ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cutting Drawing Objects (https://www.excelbanter.com/excel-discussion-misc-queries/40123-cutting-drawing-objects.html)

LostNFound

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.

Mark Hone

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.


Dave Peterson

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

Michael

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.



All times are GMT +1. The time now is 09:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com