Excel Guides

Deleting All Graphics in Excel

Deleting all graphics in Excel can be a tedious and time-consuming task, especially if there are a lot of graphics in the workbook. However, there are a few ways to delete all graphics from an Excel workbook.

Method 1: Delete All Graphics Using the Right-Click Context Menu

The first method to delete all graphics from an Excel workbook is to use the right-click context menu. To do this, simply right-click on any graphic in the workbook and select "Delete" from the menu that appears. This will delete all graphics in the workbook.

Method 2: Delete All Graphics Using VBA

Another way to delete all graphics from an Excel workbook is to use VBA. To do this, open the Visual Basic Editor (VBE) by pressing Alt+F11 on your keyboard. Then, insert a new module into the project by going to Insert > Module. Next, copy and paste the following code into the module:

Sub DeleteAllGraphics() 
'Declare variables 
Dim oSh As Shape 
 Dim ws As Worksheet 
'Loop through each worksheet in the active workbook 
 For Each ws In ActiveWorkbook.Worksheets 
'Loop through each shape in the worksheet 
 For Each oSh In ws.Shapes 
'Delete the shape 
 oSh.Delete 
 Next oSh 
 Next ws 
End Sub

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.