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

Fix broken Excel macros instantly (no coding): https://vba.teachexcel.com/?utm_source=youtube
Excel Quickie 35: https://www.youtube.com/watch?v=sFkn9Cjam-0
VBA/Macros Course (40% Discount): https://www.teachexcel.com/vba-course-update.php?src=youtube_v_description_UryiCSJeSJI
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!

TeachExcel.com

#excel #tutorial #howto

Видео Quickly Delete All Objects, Images, Charts & Shapes from Excel - #Excel Quickie 36 канала TeachExcel