ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   delete multiple autoshapes or objects in excel (https://www.excelbanter.com/excel-discussion-misc-queries/67550-delete-multiple-autoshapes-objects-excel.html)

ron

delete multiple autoshapes or objects in excel
 
Hi, how do I delete multiple autoshapes or objects in excel without using
rightmouse click-cut or delete one by one?

Dave Peterson

delete multiple autoshapes or objects in excel
 
click on the first, ctrl-click on subsequent. Then delete all the selected
shapes with one delete key.

Or show the drawing toolbar.
Click on the arrow icon and lasso the shapes you want to delete and hit the
delete key.

You could also customize a toolbar:
tools|customize|commands tab
drag the select multiple objects to your favorite toolbar.

Then click this button, select the pictures/objects you want gone and hit the
delete key.

ron wrote:

Hi, how do I delete multiple autoshapes or objects in excel without using
rightmouse click-cut or delete one by one?


--

Dave Peterson

HornJM

delete multiple autoshapes or objects in excel
 
Ron,

Select the first autoshape, hold down shift, then select (left mouse click)
all the shapes you want to delete, release the shift key and press delete.
You could also right click (I think the mouse has to be over one of your
selections) and select delete or cut.

Hope that works for you.

"ron" wrote:

Hi, how do I delete multiple autoshapes or objects in excel without using
rightmouse click-cut or delete one by one?


ron

delete multiple autoshapes or objects in excel
 
Hi Dave, thats was a great help, it worked


All times are GMT +1. The time now is 06:34 PM.

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