Quickly Delete All Objects, Images, Charts & Shapes from Excel - #Excel Quickie 36

Simple method for quickly analyzing and deleting All Objects from Excel - this includes images, shapes, charts & shapes in the worksheet.

This method will save you a lot of time compared to individually selecting images or objects and deleting them by hand.

If you import data into Excel, especially from the web, this is a very quick method for cleaning out (removing) all images and non-text based context from the worksheet.

This is a great tip that I previously included within a data cleaning tutorial but it saves so much time that I decided to put it here in its own little Excel Quickie.

Enjoy!

#excel #tutorial #howto

[jnevarez]

this is how tutorials need to be. no fluff. no talking about a bunch of non pertinent stories. just this is how its done. the end. Thankyou very much

[monicap]

Thank you so very much. :-) Straight to the point and got the task done in a few seconds by following your directions. I spent more time in Excel searching for the answer, which wasn't there, than I did in listening to your explanation and doing it.

[wayneedmondson]

Nice one! Another method.. select/click on any single object in the worksheet, press CTRL+a which will then select all other objects in the worksheet and then press Delete to delete them all. Thanks for sharing :)) Thumbs up!!

[makisalimhussain]

Awesome,
Alternatively you can go Home tab - Find & Select - Go to special, then select objects.
Now all objects are selected then press delete button to delete all objects.
Thanks

[sarahayman]

Wow thank you so much. That was super easy and useful ❤️

[paulj]

How about deleting all charts from multiple worksheets within the workbook??

[ballhawk]

Excellent, a tutorial that finally worked! They could hardly have made it more complicated when designing the bloody program. Is there a way to prevent this junk from being pasted in the first place?

[kallurseshagirirao]

Thanks a lot, this option saves lot of time. You are awesome .... :)

[sherryizzie]

Wow...nice trick! Thanks for sharing it!

[ibrarhussain]

Thank you so much. By this solution I get rid off all hidden opjects are removed from my Office working file that cause to hang the Work sheets. Thanks allot.

[AnTiViRuS]

this video is gonna save me a lot of time
tnx!

[entertainmentgalaxy]

super magic quickie.... thanks for sharing.

[satishacharya]

If I have images in other sheet as well, so how can we delete all at once, pls advise

[abuzarkamaal]

Thank you very much, very useful, i was fighting to fixit.

[sameerkmr]

Thank you soo much. I got solved the issue that I am facing for soo long...