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!

4 ★ | 2 Vote

May be interested

  • How to Delete a File in Microsoft Windows Using Batch FilesHow to Delete a File in Microsoft Windows Using Batch Files
    this wikihow teaches you how to delete a file on your windows computer by using a batch file. batch files are small files which can run commands via your computer's built-in command prompt program. once you understand how to create a basic...
  • How to convert CSV files to Excel in bulkHow to convert CSV files to Excel in bulk
    with just a few simple operations, we can batch transfer csv files to excel.
  • How to remove duplicates in excelHow to remove duplicates in excel
    to delete the same lines and figures in excel data sheet, we can use available features like remove duplicate or manually delete through the hightlight section.
  • How to add rows and delete rows in ExcelHow to add rows and delete rows in Excel
    adding rows, deleting rows in excel adds new locations in the table to enter data content, and there are ways to add rows or delete rows in excel.
  • How to reduce the size of batch photos fastestHow to reduce the size of batch photos fastest
    how to reduce the size of batch photos fastest. reducing the image size allows you to store more images. at the same time when sending to your friends or posting online will be quick because the small image size, you will upload faster. currently there are many c
  • How to delete selfies and photos tagged on Facebook?How to delete selfies and photos tagged on Facebook?
    social networking facebook not only allows us to update status but also allows us to upload photos anywhere, anytime as long as there is an internet connection. however, after a while, there may be photos that we don't want to post. besides, sometimes, you are tagged in advertising photos that are not related to you, causing discomfort but don't know how to delete them. please refer to our guide below to know how to handle it.
  • How to delete duplicate photos, the same photo on Android phonesHow to delete duplicate photos, the same photo on Android phones
    after a long time of use, our phones will have a lot of duplicate photos from applications, downloads, screenshots, ... they will consume a lot of space on our memory. if we manually filter and delete, it will take a lot of time and even take photos.
  • 8 How to delete blank rows in ExcelHow to delete blank rows in Excel8 How to delete blank rows in ExcelHow to delete blank rows in Excel
    empty rows of data can be a major annoyance. here are 8 ways to delete blank rows in excel. how to delete blank lines in excel
  • How to delete, add columns in ExcelHow to delete, add columns in Excel
    adding columns in excel or deleting columns is a basic operation and very simple in excel when we process excel tables.
  • This is a simple way to find and delete Hyperlink in ExcelThis is a simple way to find and delete Hyperlink in Excel
    if spreadsheet excel has many hyperlinks, then you want to remove these hyperlinks. however, with so many hyperlinks, removing hyperlinks will take a long time. so how to find and delete all hyperlinks on excel file, please refer to the following article of network administrator.