When making Excel file customer information, staff or product file will always accompany the image beside. Instead of manually executing, you can insert image files in bulk into Excel and can also delete batches of photos quickly. For long data tables, if you want to delete all inserted images and leave only data, you can refer to the following article of Network Administrator. The entire image is quickly deleted after taking a few simple steps, instead of sitting manually deleting each photo.
Method 1: Delete multiple photos in Excel with Go To Special
Step 1:
The user opens the Excel file to delete the image and then press F5 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 the Objects content below and click OK to continue.
Step 3:
Then the whole image is framed as below and we just need to press the Delete button to delete the image and finish.
Method 2: Delete bulk photos on Exce with VBA Macros
Step 1:
We click on the Developer tab on the Ribbon and then click on Visual Basic . Or, press Alt + F11 to quickly open VBA.
Step 2:
Display Microsoft Visual Basic interface for Applications, click the Insert menu above and then select the 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 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 all deleted photos in Excel file.
2 ways to delete photos in bulk in Excel file above are simple and fast. However, with the way 2 needs to use the code, you can use the way to Go to Special to delete the Excel image.
I wish you all success!
ncG1vNJzZmismaXArq3KnmWcp51ktbDDjK2mZpyVobK1sYypn6isn6h6qrqMm6ylo12eu26x15ycpQ%3D%3D