Removing all objects from Excel

A lot of systems allow us to export data to Excel, which can be very handy for sorting or filtering. However, I have found a few exports which can be cluttered with extraneous images; and getting rid of those images can be fairly labour intensive. In the past I did not realise that there is a simple "select all" for objects and remove.

How we do that is to go to Excel, and go to the "Find and Select" tool on the Home Ribbon, in the "Editing" area. To select all the images, we simply click the "Find and Select" tool and select "Go to Special", then select "objects". All images will now be removed.

And it is just that easy.

Sam

References:

Jenkins, M. (2023, August 3). How to Remove (or Select) All Pictures / Objects From an Excel Workbook. Automate Excel. https://www.automateexcel.com/how-to/remove-all-pictures/