How to batch delete photos in Excel - No need to delete them manually
When creating an Excel file with customer information, employee information or product files, there will always be images next to them. Instead of doing it manually, you can batch insert image files into Excel and can also quickly batch delete images. For long data tables, if you want to delete all inserted images and leave only the data, readers can refer to the following article of Network Administrator. All images are quickly deleted after following a few simple steps, instead of manually deleting each image.
Method 1: Delete multiple photos in Excel using Go To Special
Step 1:
The user opens the Excel file that wants to delete the image and then presses the F5 key to open the Go To dialog box. In this dialog box, click on the Special button .
How to batch delete photos in Excel - No need to delete them manually Picture 1
Step 2:
Display the Go To Special interface, select Objects below and click OK to continue.
How to batch delete photos in Excel - No need to delete them manually Picture 2
Step 3:
Then the entire image is framed as below and we just need to press the Delete button to delete the image and you're done.
How to batch delete photos in Excel - No need to delete them manually Picture 3
Method 2: Batch delete images on Excel using VBA Macros
Step 1:
We click on the Developer tab on the Ribbon and then click on Visual Basic . Or you press the key combination Alt + F11 to quickly open the VBA program.
How to batch delete photos in Excel - No need to delete them manually Picture 4
Step 2:
Display the Microsoft Visual Basic for Applications interface, click the Insert menu above and then select Module .
How to batch delete photos in Excel - No need to delete them manually Picture 5
In this interface, enter the code below into the code input interface.
Sub DeleteAllPics() Dim Pic As Object For Each Pic In ActiveSheet.Pictures Pic.Delete Next Pic End Sub
How to batch delete photos in Excel - No need to delete them manually Picture 6
Step 3:
After entering the code into the Module1 (Code) interface, we click on the Run button to execute the command for Excel.
How to batch delete photos in Excel - No need to delete them manually Picture 7
When finished running, turn off the Visual interface and get the results of all deleted images in the Excel file.
How to batch delete photos in Excel - No need to delete them manually Picture 8
The two ways to batch delete photos in Excel files above are both equally simple and quick. However, method 2 requires the use of code, so you can always use the Go to Special method to delete Excel images.
Wishing you success!
You should read it
- Instructions for inserting an image into an Excel spreadsheet
- How to insert a batch image into Excel box
- Insert image object in Excel
- How to insert pictures into an Excel comment box
- How to delete photos in bulk in Excel
- How to fix the insert image in Excel
- MS Excel 2007 - Lesson 9: Insert images and graphics into a spreadsheet
- How to insert a fixed image into a cell in excel
- Microsoft introduced a new tool to turn an image table into an editable Excel table
- How to insert images into Excel spreadsheets
- Steps to export data from photos to MS Excel sheet on Android
- How to insert a Word document into an Excel file
May be interested
How to fix the error of not being able to print images in Word - Images are not displayed
How to handle spaced letters in Microsoft Word
Instructions for inserting text into images in Word - Design banners, greeting cards,...
How to insert a signature into PDF with Foxit Reader - Create a personal touch on PDF documents
How to insert videos into Word is very simple
How to fix We Found a Problem With Some Content error in Excel