Download Article
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
-
Open your workbook in Excel. 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] X Research source
-
Navigate to the worksheet that has the images you want to remove. The sheets are separated by tabs at the bottom of your screen. [2] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to sourceAdvertisement
-
Click the Home tab. It's at the top of your screen in the editing ribbon. [3] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
-
Click Find & Select . You'll find this in the "Editing" grouping. [4] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
-
Click Go To Special . It's near the middle of the menu that dropped down from "Find & Select." [5] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
-
Click to fill in the circle next to Objects and click OK . This will prompt Excel to locate and select all the objects in your current worksheet. [6] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- 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.
-
Press Delete on your keyboard. Pressing this will instantly delete and remove all the selected objects from your Excel sheet.
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
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
References
- ↑ https://edu.gcfglobal.org/en/excel2016/creating-and-opening-workbooks/1/
- ↑ https://support.microsoft.com/en-us/office/select-worksheets-096b40c9-0ee7-4980-bac6-cc92aec7b266
- ↑ https://support.microsoft.com/en-us/office/find-and-select-cells-that-meet-specific-conditions-2d686424-6150-4015-a8e4-a5990f4d7e3a
- ↑ https://support.microsoft.com/en-us/office/find-and-select-cells-that-meet-specific-conditions-2d686424-6150-4015-a8e4-a5990f4d7e3a
- ↑ https://support.microsoft.com/en-us/office/find-and-select-cells-that-meet-specific-conditions-2d686424-6150-4015-a8e4-a5990f4d7e3a
- ↑ 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 35,491 times.
Advertisement