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.

Method 1: Select all pictures manually

In many cases, the manual way might be the fastest (but most troublesome as well). Hold the Ctrl key and click on each image separately. This also works of you press and hold the Shift key and click on each picture.

Method 2: Select all images manually but using the selection pane

Select all pictures in your Excel file with the selection pane.

Maybe a little bit more convenient but still manual: Using the selection pane.

1. Click on “Find & Selection” on the right hand side of the Home ribbon.
2. Click on “Selection Pane”
3. Now you can hold down the Ctrl key and click on each picture in the list.

The difference to method 1 is, that it’s more convenient to select from a list than scroll up and down your whole worksheet.

Method 3: The fast but inaccurate way

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.

1. Go to “Find & Select” in the Home ribbon
2. Click on “Go To Special”
3. Select “Objects”
4. Click “OK”

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

Method 4: The more complicated but accurate way (VBA)

There is a short VBA code (don’t panic, just follow the steps below ;-):

1. Go to the worksheet with all the pictures you want to select.
2. Press Alt + F11 for opening the VBA editor.
3. Press Alt + G for opening the “Immediate”-Window.
4. Paste this code ActiveSheet.Pictures.Select and press Enter .

Method 5: The convenient way 

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“.

1. Click on the “Reduce File” button on the right hand side of the Professor Excel ribbon.
2. Set the ticks at “Reduce size of pictures” and/or “Delete all pictures”.
3. Set the scope: All worksheets, selection from the list above or just the currently active worksheet.
4. Click on “Start”.

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.

---