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 .
Step 2:
Display the Go To Special interface, select Objects below and click OK to continue.
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.
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.
Step 2:
Display the Microsoft Visual Basic for Applications interface, click the Insert menu above and then select Module .
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
Step 3:
After entering the code into the Module1 (Code) interface, we click on the Run button to execute the command for Excel.
When finished running, turn off the Visual interface and get the results of all deleted images in the Excel file.
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
- 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
May be interested
- How to Delete a File in Microsoft Windows Using Batch Filesthis 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 bulkwith just a few simple operations, we can batch transfer csv files to excel.
- How to remove duplicates in excelto 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 Exceladding 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. 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?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 phonesafter 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 Excelempty 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 Exceladding 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 Excelif 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.