ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can you remove all objects in a worksheet at once? (https://www.excelbanter.com/excel-discussion-misc-queries/69732-how-can-you-remove-all-objects-worksheet-once.html)

rjmills18

How can you remove all objects in a worksheet at once?
 

How can you remove all objects in a worksheet at once? graphs etc, if
its possible!


--
rjmills18
------------------------------------------------------------------------
rjmills18's Profile: http://www.excelforum.com/member.php...o&userid=31203
View this thread: http://www.excelforum.com/showthread...hreadid=508785


Ron Coderre

How can you remove all objects in a worksheet at once?
 

Try this:

Select the sheet with the objects
EditGo To
Click the [Special] button
Check: Objects
Click the [OK] button

That should select all of the objects on that sheet.
Press the [Delete] key

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=508785



All times are GMT +1. The time now is 02:53 AM.

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