Select all Pictures in Excel: 5 Easy Methods
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
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.
- Click on “Find & Selection” on the right hand side of the Home ribbon.
- Click on “Selection Pane”
- 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.
- Go to “Find & Select” in the Home ribbon
- Click on “Go To Special”
- Select “Objects”
- 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
Excel too slow? Speed it up. Get the book now!
Tired of waiting for Excel? Use the 30 best methods described in this book to speed up Excel calculations!
- Learn how Microsoft Excel performs calculations
- Use the simple and effective step-by-step guide to master each method
- Get to know the impact each method will have on performance
Learn more or get it on Amazon!
Method 4: The more complicated but accurate way (VBA)
There is a short VBA code (don’t panic, just follow the steps below ;-):
- Go to the worksheet with all the pictures you want to select.
- Press Alt
+ F11 
for opening the VBA editor. - Press Alt + G
for opening the “Immediate”-Window. - 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“.
- Click on the “Reduce File” button on the right hand side of the Professor Excel ribbon.
- Set the ticks at “Reduce size of pictures” and/or “Delete all pictures”.
- Set the scope: All worksheets, selection from the list above or just the currently active worksheet.
- 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.
