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.
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.
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