Delete Multiple Objects All At Once In #Excel

Here’s how you can delete all the objects or form controls at one time in Excel:

I have a large order form with lots of check boxes that were inserted using the Insert button for Form Controls on the Developer tab:

Del1

Del2

It would be quite time consuming to individually delete these, so I need a quick and easy way to select and delete them all at once. Excel to the rescue! To select all these objects simultaneously, just click on the F5 key, which will bring up the Go To dialog box. Then click on the Special button:

Del3

Another dialog box will appear. From here, select Objects and click OK:

Del4

Excel now has selected all the objects on your worksheet:

Del5

At this point, just click your Delete key, and all the check boxes are gone!

Del6

Voila!

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, , , ,

One Response to Delete Multiple Objects All At Once In #Excel

  1. Naveen November 21, 2013 at 12:25 am #

    Notify me of new posts by email.

Leave a Reply