How to quickly delete all autoshapes in Excel?
When your Excel worksheet is cluttered with autoshapes, such as rectangles, lines, or arrows—it can be tedious to delete them one by one. Fortunately, this article compares three practical methods that vary in precision and flexibility, from basic built-in tools to one-click advanced solutions.
- Use Go To Special to delete all objects
- Use VBA to delete all shapes (charts, picture included)
- Use Kutools for Excel to precisely remove only autoshapes
Use Go To Special to delete all objects
This is the most commonly used method by Excel users to remove shapes, because it's built into Excel and doesn't require any coding or add-ins. However, there's an important caveat:
Here is how to use the Go To Special function to handle this task.
- Press "F5" or "Ctrl" + "G" to open the "Go To" dialog box, then click "Special..".
- Choose "Objects", then click "OK". All objects (including shapes, images, etc.) will be selected.
- Press Delete or Backspace to remove them all.
Use VBA to delete all shapes (charts, picture included)
If you prefer automation, a simple VBA script can delete all shapes in the active worksheet in one go.
- Hold down the "ALT" + "F11" keys to open the "Microsoft Visual Basic for Applications" window.
- Click "Insert" > "Module", and paste the following macro into the "Module" window.
VBA: delete all shapes in active worksheet
Sub DeleteShapes() Dim Shp As Shape For Each Shp In ActiveSheet.Shapes Shp.Delete Next Shp End Sub
- Press the F5 key to run this macro.
All shapes, including autoshapes, charts, and pictures will be deleted from the active sheet.
Use Kutools for Excel to precisely remove only autoshapes
Kutools for Excel offers a dedicated tool called “Delete Illustrations & Objects”, allowing you to precisely remove only shapes from your current worksheet, selected sheets, or the entire workbook.
Kutools for Excel - Packed with over 300 essential tools for Excel. Enjoy permanently free AI features! Download now!
After installing Kutools for Excel, select "Kutools" > "Delete" > "Delete Illustrations & Objects". Then configure the dialog as follows:
- In the "Delete" section, choose "Auto shapes".
- In the "Look in" section, choose:
- "Active sheet" - delete shapes in the current worksheet.
- "Selected sheets" – choose specific sheets to process.
- "All sheets" – remove shapes from the entire workbook.
- Click "OK".
Kutools for Excel - Supercharge Excel with over 300 essential tools. Enjoy permanently free AI features! Get It Now
Relative articles:
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!