Tip of the Day | Monday October 13th, 2025

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Delete All Objects in Selected Worksheet(s)

This tool removes all objects from the selected worksheet(s) in your workbook.

For example, it will delete objects such as the following:

Shapes (including AutoShapes)

Text boxes

Pictures

WordArt

Charts

Clip Art

Form controls (from the Forms toolbar)

ActiveX controls and OLE buttons (from the Control Toolbox)

Embedded objects such as SmartArt, 3D models, or inserted files

This is useful for cleaning up sheets with leftover or hidden objects, especially after copying data from other sources or preparing worksheets for printing or sharing.

Screenshots

Objects & Comments › Delete All Objects in Selected Worksheet(s)

Starting this tool

Click ASAP Utilities › Objects & Comments › 4. Delete All Objects in Selected Worksheet(s)
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Yesterday's Tip

Tomorrow's Tip

Download

©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.