How to Delete All Images in Excel: Safe, Fast Methods

How-to basics · Updated November 20, 2026

To remove pictures and other floating objects from an Excel worksheet, first save a copy, then choose Home > Find & Select > Go To Special > Objects and press Delete. Repeat on each worksheet. This removes more than pictures, so check what is selected before deleting; in-cell images, sheet backgrounds, and header or footer images need separate treatment.

What You’ll Need

  • Excel for Microsoft 365 on Windows. The main steps also work in many desktop editions of Excel, though some ribbon labels may differ slightly.
  • Permission to edit the workbook and, if sheets are protected, the password or access needed to unprotect them.
  • A backup copy of the workbook. Deleting selected objects can often be undone immediately, but a saved copy gives you a safer way to recover if you make further changes.

Step-by-Step

  1. Save a separate copy of the workbook. Choose File > Save As and save a copy with a different name or in a different folder. This is especially important if the workbook contains charts, buttons, diagrams, or other objects that you may want to keep. Deleting all selected objects can remove these along with pictures.
  2. Open the first worksheet you want to clean. Click its sheet tab. The Go To Special object selection applies to the active worksheet, not automatically to every sheet in the workbook. If a sheet is hidden, right-click a visible sheet tab, choose Unhide, and show the sheet before cleaning it. You may need permission to unprotect a protected sheet.
  3. Open Go To Special. On the ribbon, select Home > Find & Select > Go To Special. In the dialog, choose Objects, then click OK. Excel selects the floating objects it recognizes on that worksheet. These can include inserted pictures, shapes, charts, text boxes, and some controls or embedded objects—not just photographs.
  4. Review the selection before removing it. Look over the sheet for selection outlines or handles. If a chart, logo, drawing, button, or other object should stay, press Esc to cancel the selection. You can then remove unwanted items individually, or use the Selection Pane to inspect and manage objects by name. Do not press Delete if you are unsure what is selected.
  5. Delete the selected objects. Once you are satisfied that everything selected can be removed, press the Delete key. The selected objects disappear from that worksheet; cell values and ordinary formulas are not deleted by this command. If the result is wrong, use Ctrl+Z immediately on Windows (or Command+Z on Mac) to undo, then review the selection again.
  6. Repeat for every worksheet. Click the next sheet tab and repeat Home > Find & Select > Go To Special > Objects, then review and delete. Continue through visible sheets and any hidden sheets you want included. Avoid assuming that selecting objects on one sheet has selected objects elsewhere.
  7. Check for image types the object selector does not remove. If the workbook still displays images, check whether they are in-cell images, a worksheet background, or pictures placed in headers or footers. These are handled differently; see the sections below and the troubleshooting advice.
  8. Save and verify the workbook. Save the cleaned copy, then revisit each relevant sheet at normal zoom. Check print preview as well if the workbook is used for printing, since header and footer pictures can appear there even when the worksheet grid looks clear.

Mac: The desktop Mac version also has a Go To Special command, though ribbon placement and labels can vary by release. Look under Home for Find & Select or use Edit > Find > Go To, then choose Special and Objects if available. Press Delete to remove the selection; use Command+Z to undo. If your version does not show the Objects option, use the Selection Pane to remove objects individually.

Worksheet backgrounds: A background is displayed behind cells but is not a normal floating picture. To remove it, open the worksheet and choose Page Layout > Delete Background. This command removes the background from the active sheet; repeat on other sheets with backgrounds.

Header and footer pictures: These may not appear in the regular grid or be selected as worksheet objects. Open Insert > Header & Footer, click the header or footer section containing the picture, and remove the picture reference shown there (often displayed as &[Picture]). Check the left, center, and right sections, and inspect both header and footer areas. The picture may be easiest to see in Page Layout view or print preview.

Common Mistakes

  • Assuming “Objects” means pictures only. Excel’s object selection is broad. It can also select shapes, charts, diagrams, text boxes, and controls. Deleting all of them may damage a dashboard or remove interactive buttons. Review the selection or use the Selection Pane to identify items before pressing Delete.
  • Running the command once and expecting the whole workbook to be cleared. Go To Special works on the active worksheet. Work through the tabs one at a time, including hidden sheets if they are in scope. Be careful when grouping sheets: avoid making a deletion while multiple sheets are grouped, since edits to grouped sheets can affect more than one sheet.
  • Confusing an image in a cell with a picture placed over cells. A floating picture sits above the grid and is generally selected by Go To Special. An in-cell image behaves more like cell content and may remain after the object-selection method. Clearing a cell to remove an image can also erase a value or formula, so identify the cell contents first.
  • Deleting before checking the selection. A company logo, chart, or form control may be important even if it looks like a picture. If you notice an unwanted item has disappeared, use Undo before making more edits. Undo may no longer be available after closing the workbook or performing later actions.
  • Forgetting non-grid pictures. A worksheet background and a header or footer picture can remain visible in specific views or on printed pages. They need separate checks and removal steps, even if the sheet appears empty in Normal view.

Tips

  • Use the Selection Pane for a controlled cleanup. Choose Home > Find & Select > Selection Pane to display a list of objects on the active sheet. Select an item in the list to locate it, or use the visibility controls to hide it temporarily. This is useful when you need to keep charts or controls and remove only pictures. Pane features can vary slightly across Excel releases.
  • Test on one sheet first. If the workbook has many object types, clean a copy of one representative sheet and verify that no required items were removed. Once you understand what Excel selects in that workbook, repeat the process carefully on the other sheets.
  • Keep an inventory of objects you need. Before a broad cleanup, note the location of charts, buttons, logos, and other non-image items. You can also use the Selection Pane to inspect object names. Names may be generic, so click an entry and check what it outlines on the worksheet.
  • Remember that hiding is not deleting. Hiding an object in the Selection Pane only changes whether it is displayed; the object remains in the workbook. If the goal is to remove it from the file, select it and delete it after confirming it is not needed.
  • Save in the workbook’s existing format. If the file contains macros or special features, preserve its appropriate format when saving—for example, keep a macro-enabled workbook as an .xlsm file. Saving a copy before cleanup helps protect the original format and content.
  • Use Excel desktop for broad object selection. Excel for the web has fewer object-management options, and the Go To Special workflow may not be available in the same way. If you cannot select objects as described, open the file in the desktop app or use the web version’s available Selection Pane controls to remove objects individually.

Troubleshooting

Go To Special does not select anything: The sheet may have no floating objects, or the remaining pictures may be in cells, in a background, or in headers and footers. Check those locations separately. Also confirm that you are on the intended worksheet rather than a different tab.

The pictures remain after pressing Delete: Check whether the objects were locked or the sheet is protected. If you have permission, use Review > Unprotect Sheet and try again. If the sheet requires a password, ask the workbook owner rather than trying to bypass protection. Also check for in-cell images and background or header/footer pictures, which are outside the usual floating-object selection.

Too many items disappeared: Press Ctrl+Z on Windows or Command+Z on Mac right away. Then reopen the Selection Pane and delete only the entries that correspond to pictures. If you already saved, closed the file, or cannot undo, restore the backup copy or use your organization’s version history if available.

You cannot find an image in the Selection Pane: Make sure the correct sheet is active and that the image is not in a header, footer, or background. An in-cell image may be represented as cell content rather than a floating object. Select the relevant cell and inspect the formula bar or cell contents before clearing anything; do not clear a whole range unless you have confirmed it contains no data you need.

The option is missing in Excel for the web: Some desktop selection commands are not exposed in the web app. Choose Open in Desktop App if available, then use the Windows or Mac steps above. If desktop Excel is unavailable, use the Selection Pane if your web version provides it, and remove objects one at a time.

The image only shows when printing: Open print preview and inspect the page margins and header/footer areas. Remove a picture reference from the relevant header or footer section. If the image is behind the cells across the sheet, use Page Layout > Delete Background instead.

Frequently Asked Questions

Can I delete every picture in a workbook at once?
Excel’s Go To Special > Objects command selects objects on the active sheet, not the entire workbook. Repeat it on each worksheet. For a large workbook, check the sheet tabs and hidden sheets so you do not overlook any.

Does selecting Objects delete charts and shapes too?
It can. Objects is not a pictures-only filter, so charts, shapes, text boxes, and controls may be selected along with pictures. Inspect the selection first, or use the Selection Pane to remove only the entries you want gone.

Will deleting objects remove cell data?
Deleting selected floating objects normally leaves cell values and formulas intact. However, clearing a cell to remove an in-cell image can also erase that cell’s value or formula, so check the contents before clearing it.

How do I remove an Excel background image?
On the sheet with the background, choose Page Layout > Delete Background. Repeat on each sheet where a background was added. This is separate from deleting a picture placed over the worksheet cells.

Can I remove images in Excel for the web?
Possibly, depending on the object’s type and the controls available in your version. If you cannot access a suitable object-selection command or Selection Pane, open the workbook in desktop Excel and use Go To Special or the Selection Pane there.

How can I get a deleted picture back?
Use Ctrl+Z on Windows or Command+Z on Mac immediately after deleting it. If Undo is no longer available, restore the saved backup or check whether a usable earlier version is available through your storage service.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.