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

Sample Worksheet filled with Objects & AutoShapes.

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

Using F5 to launch the Go To dialog box

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

Choose Objects and Click OK button.

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

Using Go To dialog box to select and remove all objects from a worksheets

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.

Choose Module from the Insert Menu

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

–Narendhiran Vijayakumar.

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.