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

Опубликовано: 30 Сентябрь 2024
на канале: TeachExcel

87,186

697

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