

When you copy content from a webpage and paste it into Excel, not only the text and numbers are pasted, but also pictures. As often as not, you don’t want to keep these images for example website logos. They make your Excel file large, hide your data and make you worksheet look messy. Instead of deleting one by one, you can easily select all pictures at the same time. Let’s take a look at 5 different methods.
Contents
In many cases, the manual way might be the fastest (but most troublesome as well). Hold the Ctrl
Select all pictures in your Excel file with the selection pane.
Maybe a little bit more convenient but still manual: Using the selection pane.
The difference to method 1 is, that it’s more convenient to select from a list than scroll up and down your whole worksheet.
Select all pictures in Excel with Go To Special.
There is a shortcut to help select all images at the same time. With this method you can delete all images once, instead of deleting each picture separately.
The disadvantage of this method: All objects, e.g. images, buttons, text boxes, are selected. Not only picture. If you don’t have any objects like buttons or charts on your worksheet just go ahead. Otherwise please use any of the other methods
There is a short VBA code (don’t panic, just follow the steps below ;-):
Compress or delete all pictures in your file with Professor Excel Tools.
If you want to compress or delete all picture, you can conveniently use the Excel add-in “Professor Excel Tools“.
You don’t have “Professor Excel Tools” yet? Try it for free – no sign-up, no installation needed (just activate it within Excel). Just download it with the button below.
This function is included in our Excel Add-In 'Professor Excel Tools'
Learn more Download Free Trial
(No sign-up, download starts directly)
More than 10k people on Facebook can't be wrong.
'Professor Excel Tools': Add more than 60 amazing features to Excel!
Professor's Error Helper for Excel: Solve any error in Excel.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
Subscribe to our popular Excel newsletter! You get all this:
Your welcome gift: Our big 45 pages keyboard shortcuts package.
Subscribe now! In case the sign-up form above doesn't work, please use this page. Sorry for the inconvenience.
Please use this download link to download the Currency Converter Excel add-in!
Please use this download link to download the comment extraction example: http://bit.ly/Extract_Comment_Example
Comments 2
Mocha
Thank you! I am creating a product catalogue for my company using Excel (bad decision, I know, but I don’t pull the strings) and my Excel spreadsheet had over a hundred images I needed to move just slightly to the right. Didn’t have anything else other than the images, so Method 3 worked well for me. Thank you again!
Jan
Needs correction: Alt+G –> Ctrl+G
I tried Method 4 in MS Excel 2003
and Alt+G does not work. Instead, I found that Ctrl+G does the job.
Please, before update, verify that it was not changed for newer versions of Excel. Thank you.