How to Quickly Delete All Images in Excel in 3 Steps

PDF download Download Article
PDF download Download Article

Are you looking for a way to delete all the images in your Excel worksheet? You can select all the images and delete them instantly with a few clicks of your mouse! This wikiHow article teaches you how to quickly and easily delete all images in Excel on your computer.

Steps

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9d\/Delete-All-Images-in-Excel-Step-1.jpg\/v4-460px-Delete-All-Images-in-Excel-Step-1.jpg","bigUrl":"\/images\/thumb\/9\/9d\/Delete-All-Images-in-Excel-Step-1.jpg\/v4-728px-Delete-All-Images-in-Excel-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You can open Excel then click File > Open to open your workbook or you can right-click the file in your file manager and select Open with > Excel . [1]
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6b\/Delete-All-Images-in-Excel-Step-2.jpg\/v4-460px-Delete-All-Images-in-Excel-Step-2.jpg","bigUrl":"\/images\/thumb\/6\/6b\/Delete-All-Images-in-Excel-Step-2.jpg\/v4-728px-Delete-All-Images-in-Excel-Step-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    The sheets are separated by tabs at the bottom of your screen. [2]
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/95\/Delete-All-Images-in-Excel-Step-3.jpg\/v4-460px-Delete-All-Images-in-Excel-Step-3.jpg","bigUrl":"\/images\/thumb\/9\/95\/Delete-All-Images-in-Excel-Step-3.jpg\/v4-728px-Delete-All-Images-in-Excel-Step-3.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    It's at the top of your screen in the editing ribbon. [3]
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/07\/Delete-All-Images-in-Excel-Step-4.jpg\/v4-460px-Delete-All-Images-in-Excel-Step-4.jpg","bigUrl":"\/images\/thumb\/0\/07\/Delete-All-Images-in-Excel-Step-4.jpg\/v4-728px-Delete-All-Images-in-Excel-Step-4.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You'll find this in the "Editing" grouping. [4]
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4d\/Delete-All-Images-in-Excel-Step-5.jpg\/v4-460px-Delete-All-Images-in-Excel-Step-5.jpg","bigUrl":"\/images\/thumb\/4\/4d\/Delete-All-Images-in-Excel-Step-5.jpg\/v4-728px-Delete-All-Images-in-Excel-Step-5.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    It's near the middle of the menu that dropped down from "Find & Select." [5]
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cd\/Delete-All-Images-in-Excel-Step-6.jpg\/v4-460px-Delete-All-Images-in-Excel-Step-6.jpg","bigUrl":"\/images\/thumb\/c\/cd\/Delete-All-Images-in-Excel-Step-6.jpg\/v4-728px-Delete-All-Images-in-Excel-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This will prompt Excel to locate and select all the objects in your current worksheet. [6]
    • Not only will Excel select all the images in your sheet, but it will also select any objects in the sheet including charts, shapes, screenshots, icons, 3D models, and SmartArt. If there are objects you don't want to select, click them to unselect them.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5b\/Delete-All-Images-in-Excel-Step-7.jpg\/v4-460px-Delete-All-Images-in-Excel-Step-7.jpg","bigUrl":"\/images\/thumb\/5\/5b\/Delete-All-Images-in-Excel-Step-7.jpg\/v4-728px-Delete-All-Images-in-Excel-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Pressing this will instantly delete and remove all the selected objects from your Excel sheet.
    8. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Recover a Corrupt Excel File
      How to Merge Cells in Microsoft Excel: A Quick Guide
      Easily Create a Drop-Down List in Microsoft Excel: Setup & Customization
      How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      How to Create a Graph in Excel
      How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Link Sheets in Excel
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to Unhide Multiple Rows in Microsoft Excel
      How to Combine Columns in Excel Without Losing Data
      How to Create an Inventory List in Microsoft Excel: Step-by-Step Guide
      Advertisement

      References

      1. ↑ https://edu.gcfglobal.org/en/excel2016/creating-and-opening-workbooks/1/
      2. ↑ https://support.microsoft.com/en-us/office/select-worksheets-096b40c9-0ee7-4980-bac6-cc92aec7b266
      3. ↑ https://support.microsoft.com/en-us/office/find-and-select-cells-that-meet-specific-conditions-2d686424-6150-4015-a8e4-a5990f4d7e3a
      4. ↑ https://support.microsoft.com/en-us/office/find-and-select-cells-that-meet-specific-conditions-2d686424-6150-4015-a8e4-a5990f4d7e3a
      5. ↑ https://support.microsoft.com/en-us/office/find-and-select-cells-that-meet-specific-conditions-2d686424-6150-4015-a8e4-a5990f4d7e3a
      6. ↑ https://support.microsoft.com/en-us/office/find-and-select-cells-that-meet-specific-conditions-2d686424-6150-4015-a8e4-a5990f4d7e3a

      About This Article

      Article Summary X

      1. Open your workbook in Excel.
      2. Navigate to the worksheet that has the images you want to remove.
      3. Click the Home tab.
      4. Click Find & Select .
      5. Click Go To Special .
      6. Click to fill the circle next to Objects and click OK .
      7. Press Delete on your keyboard.

      Did this summary help you?
      Thanks to all authors for creating a page that has been read 23,017 times.

      Is this article up to date?

      Advertisement