Download ArticleDownload ArticleThis article was co-authored by How.com.vn staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for How.com.vn. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities.
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 20,083 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 How.com.vn article teaches you how to quickly and easily delete all images in Excel on your computer.
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.
Navigate to the worksheet that has the images you want to remove. The sheets are separated by tabs at the bottom of your screen.Advertisement
Click the Home tab. It's at the top of your screen in the editing ribbon.
Click Find & Select. You'll find this in the "Editing" grouping.
Click Go To Special. It's near the middle of the menu that dropped down from "Find & Select."
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.- 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. [1]
Expert Q&A
Tips
References
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.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
