Download Article
Download Article
This article was co-authored by wikiHow staff writer, Darlene Antonelli, MA. Darlene has been writing and editing tech content at wikiHow since 2019. She previously worked for AppleCare, served as a writing tutor, volunteered in IT at an animal rescue, and taught as an adjunct professor for EN101 and EN102. Darlene has completed Coursera courses on technology, writing, and language. She holds both a BA (2011) and an MA (2012) from Rowan University in Writing, with a focus on workplace communication. With her extensive experience, academic background, and ongoing learning, Darlene has become the go-to grammar expert for her friends and family, as well as a skilled wordsmith for anyone in need.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 44,491 times.
Learn more...
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.
How do you select and delete all images in Excel?
- Open your workbook in Excel.
- Navigate to the worksheet that has the images you want to remove.
- Click the Home tab.
- Click “Find & Select.”
- Click “Go To Special.”
- Click “Objects.”
- Click “OK.”
- Press Delete on your keyboard.
Steps
Download Article
-
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] -
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]Advertisement -
Click the Home tab. It's at the top of your screen in the editing ribbon.[3] -
Click Find & Select. You'll find this in the "Editing" grouping.[4] -
Click Go To Special. It's near the middle of the menu that dropped down from "Find & Select."[5] -
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]- 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.
Expert Q&A
Tips
You Might Also Like
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
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.
