How to Select and Delete All Pictures in an Excel Worksheet
Question details
The user needs to quickly select and remove all pictures or graphical objects in a spreadsheet without clicking each one manually.

- 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.
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.
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.
Open your worksheet. Go to the 'Home' tab on the ribbon, locate the Editing group on the far right, and click on 'Find & Select'.
From the drop-down menu, choose 'Go To Special...' to open the dialog box.
Check the 'Objects' radio button in the Go To Special dialog box and click 'OK'.
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 Keyboard Shortcuts (F5 or Ctrl+G)
A faster alternative using keyboard shortcuts to bypass the ribbon and directly access the Go To Special dialog.
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. Open your file in WPS Spreadsheet: Launch WPS Office and open the spreadsheet containing the images you want to delete.
- 2. Trigger the Go To dialog: Press Ctrl+G or F5 on your keyboard to bring up the 'Go To' window.
- 3. Select Objects: Click the 'Special' button, select the 'Objects' option, and confirm by clicking 'OK'.
- 4. Remove all items: With all pictures and shapes selected across the sheet, press the Delete key to clear them out.

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.




