How Can I Delete All AutoShapes, Objects in Excel?
Using Go To Dialog Box and VBA Codes to Wipe All Object and AutoShapes From Worksheets in Excel!
AutoShapes in Excel refer to predefined drawing shapes that you can insert into a worksheet to improvise visual presentation by adding lines, arrows, rectangles, circles, callouts, flowchart symbols, banners, stars, and more. Objects in Excel is also similar to the AutoShapes, but it extends upto Charts, Shapes or AutoShapes, Pictures, Text Boxes, SmartArt, Buttons or Controls, Embedded Objects, Comments or Notes and Hyperlinks.
Too much objects filled your excel sheets? It is so easy to clear all the objects and autoshapes from your worksheet using GO TO dialog box and VBA Code. In this tutorial, I will guide you to delete all objects and autoshapes instantly from your worksheets in a Excel.
Method 1: Delete Objects, AutoShapes using Go To Dialog Box
- You can use the Go To dialog box to completely wipe all the images, gif, videos and autoshapes from your worksheets.
- You need to use the keyboard shortcut CTRL + G or F5 to launch the GO TO dialog window.
- In the left bottom, you need to press the option Special…
- Then you need to choose the Objects option from the list, and click the OK button to confirm the selection.
- Once you did this, all the objects in your worksheets will be selected and then you can use the Del keyboard shortcut to remove all the objects from your worksheet.
That’s it.
⚠️This will delete all the objects and autoshapes from your sheets and so make a backup before performing options.
Method 2: Remove Objects, AutoShapes using VBA in Excel
- Use the keyboard shortcut ALT + F11 to launch the VBA editor.
- Then from the menu bar, you need to choose Insert -> Module.
- Copy and paste the code in the module.
Sub DeleteShapes()
Dim Shp As Shape
For Each Shp In ActiveSheet.Shapes
Shp.Delete
Next Shp
End Sub- Now, You need to use the Keyboard shortcut F5 to execute the command.
- A popup window will appear on your screen asking you to choose the MACROS.
- Choose the DeleteShapes MACROS and click the RUN button to clear all the autoshapes, objects from your worksheets.
That’s it.
Feel free to comment us below, if you have any queries about the above topic and find more interesting excel tutorials on our homepage: Excel24x7.com.
Recently Published Tutorials:
- How Can You Assign a Value/Category based on Number Range in Excel?
- How Do I Find Cell Contains Maximum or Minimum Values in Excel?
- How to Use a Formula to Convert Text to Sentence Case in Excel?
- How Can You Reverse Signs of Cell Values in Excel?
- How to Sync Selected Range Across All Worksheets in Excel?
