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:
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:
Another dialog box will appear. From here, select Objects and click OK:
Excel now has selected all the objects on your worksheet:
At this point, just click your Delete key, and all the check boxes are gone!