Quickly Delete All Objects, Images, Charts & Shapes from Excel -
VBA/Macros Course (40% Discount): https://www.teachexcel.com/vba-course...
Excel Quickie 35: • 3 Simple Methods for Number Formattin...
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
Watch video Quickly Delete All Objects, Images, Charts & Shapes from Excel - online without registration, duration hours minute second in high quality. This video was added by user TeachExcel 05 March 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 87,186 once and liked it 697 people.