Insert Excel Picture: How to Delete Photos in Bulk in Excel

This updated guide examines Insert Excel Picture: How to Delete Photos in Bulk in Excel and organizes the essential facts, background, and practical takeaways in clear American English.

• Instructions for inserting an image into an Excel spreadsheet
• How to insert a Word document into an Excel file
• How to insert page numbers in Excel
• Inserting letters, logos sink into Microsoft Excel 2013

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!