Select all Pictures in Excel: 5 Easy and Fast Methods!

select all pictures, excel, images, select, delete
Select all pictures in Excel at the same time.

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 computer_key_Ctrlkey and click on each image separately. This also works of you press and hold the Shift computer_key_Shiftkey and click on each picture.

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

selection, pane, select, pictures, excel, images
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 computer_key_Ctrlkey 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 (Go To Special)

go, to, special, select, all, pictures, select all picture, objects, excel
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 computer_key_Alt+ F11 computer_key_F11for opening the VBA editor.
  3. Press Ctrl computer_key_Ctrl+ G computer_key_Gfor opening the “Immediate”-Window.
  4. Paste this code ActiveSheet.Pictures.Select and press Enter computer_key_Enter.

Method 5: The convenient way (Professor Excel Tools)

This is the most convenient way because you just need two clicks and have the most detailed options: Use our Excel add-in “Professor Excel Tools“.

  1. Click on “Selection Tools”.
  2. Then, click on “Select all objects” (all objects, including images, charts, etc. are selected).
    Alternatively, only select all images by clicking on “Select all images” or charts by clicking on “Select all charts”.

That’s easy, isn’t it?

Professor Excel Tools also have a second option, if you want to delete all pictures from your complete Excel file:

Compress or delete all pictures in your file with 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.


Professor Excel Tools Box

This function is included in our Excel Add-In ‘Professor Excel Tools’

(No sign-up, download starts directly)

More than 35,000 users can’t be wrong.


Henrik Schiffner is a freelance business consultant and software developer. He lives and works in Hamburg, Germany. Besides being an Excel enthusiast he loves photography and sports.

6 comments

  1. 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!

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

Leave a comment

Your email address will not be published. Required fields are marked *