how to delete multiple autoshape or objects in excel
|
how to delete multiple autoshape or objects in excel
Click the white arrow on the drawing toolbar (select objects). Then put
the cursor (arrow) on the top left of the area where the objects are and click and hold left mouse button. Then drag the cursor across the area, making a box covering all the objects. When you release the mousebutton, all the objects should be marked and you can delete them. |
how to delete multiple autoshape or objects in excel
Hi Ron,
you should be able to select them all in one go by first clicking on the selection arrow that is on the Drawing tool bar, then starting off anywhere on the sheet that is above and to the left of all the shapes, left click (hold down mouse button) then drag to the right then down so that the selection rectangle (dotted lines) contains all of the shapes to be deleted. Each selected shape will then have visible handles and pressing the delete key will delete them. If the Drawing toolbar is not visible then go ViewToolbarsDrawing. The selection arrow is just to the right of the Draw button. Ken Johnson |
how to delete multiple autoshape or objects in excel
You can also customize the Drawing toolbar to add the Select Multiple
Objects toolbar button. Clicking it will open a little dialog box listing all the shapes on the worksheet, and it lets you select them all in a single click. To add the button, right-click on any toolbar and click "Customize ..." from the bottom of the pop-up. A dialog will open - click the Commands tab. Select "Drawing" from the "Categories" list and you'll see the "Select Multiple Objects" command on the right. Click on it a drag it down your your toolbar. HTH, Nick Hebb BreezeTree Software, LLC http://www.breezetree.com |
how to delete multiple autoshape or objects in excel
Thanks for that one Nick! I didn't know about that. It will be very
useful. Ken Johnson |
All times are GMT +1. The time now is 08:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com