Formatting Issues

How to Select and Delete All Pictures in an Excel Worksheet

Elise WilliamsElise Williams Nov 2, 2026 873 views

Question details

The user needs to quickly select and remove all pictures or graphical objects in a spreadsheet without clicking each one manually.

How to Select and Delete All Pictures in an Excel Worksheet
Product
Excel
Device & OS
not provided
Scenario
Cleaning up an Excel worksheet that contains multiple unwanted images, charts, or graphical objects.
Observed behavior
The user seeks a method or shortcut to highlight all objects at once so they can be deleted in a single keystroke.
Before you start

Ensure you are on the specific worksheet where you want to remove the images, as this selection method only applies to the currently active sheet.

Solution 1Recommended

Use the Go To Special Feature from the Ribbon

This is the standard and most visual method to locate and select all objects on a worksheet using Excel's built-in Home menu.

1
Navigate to Find & Select

Open your worksheet. Go to the 'Home' tab on the ribbon, locate the Editing group on the far right, and click on 'Find & Select'.

2
Open Go To Special

From the drop-down menu, choose 'Go To Special...' to open the dialog box.

3
Select Objects

Check the 'Objects' radio button in the Go To Special dialog box and click 'OK'.

4
Delete Pictures

All pictures, shapes, and objects on the active worksheet will now be highlighted. Press the 'Delete' key on your keyboard to remove them instantly.

Use the Go To Special Feature from the Ribbon
Selection Confirmed: Once you click OK, you will see selection handles (small circles) around every image and object on the sheet.
Efficient Spreadsheet Management

Quickly Delete All Pictures in WPS Spreadsheet

WPS Spreadsheet provides a highly compatible and intuitive interface to manage, select, and delete multiple objects seamlessly. You can achieve this using the exact same familiar shortcuts as Microsoft Excel.

  1. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the spreadsheet containing the images you want to delete.
  2. 2. Trigger the Go To dialog: Press Ctrl+G or F5 on your keyboard to bring up the 'Go To' window.
  3. 3. Select Objects: Click the 'Special' button, select the 'Objects' option, and confirm by clicking 'OK'.
  4. 4. Remove all items: With all pictures and shapes selected across the sheet, press the Delete key to clear them out.
Fully compatible with Microsoft Excel (.xlsx, .xls) files and object formatting.Familiar user interface and identical keyboard shortcuts (F5 / Ctrl+G).Lightweight application with fast loading times for heavy, image-dense spreadsheets.Free to use with a comprehensive suite of office tools.
microsoft office alternative - wps office

Frequently Asked Questions

Will Go To Special select charts and shapes as well?

Yes, choosing 'Objects' in the Go To Special dialog box will select all graphical items on the active worksheet, including pictures, charts, shapes, and text boxes.

Can I delete pictures on multiple worksheets at once?

No, the Go To Special feature only selects objects on the currently active worksheet. You will need to switch to each sheet and repeat the process.

How do I deselect one specific picture before deleting?

After using Go To Special to select all objects, you can hold down the Ctrl key and click on the specific picture you want to keep. This will deselect it while keeping the rest highlighted for deletion.

Why is the Go To Special option grayed out?

The option might be grayed out if the worksheet is protected. You must unprotect the sheet via the Review tab before you can select and delete objects.