Form Controls - Out of Control

[tlc53]

Hi,
I have a spreadsheet which visually isn't large. One particular sheet for example ranges from A1:U159 and plenty of those cells are blank/unused. There are 4 sheets in total, 2 sheets have a bit going on and the other 2 basically just have a bit of text.
However, this spreadsheet takes forever to open as it's 10,359KB large. When I check the Workbook Statistics it tells me there are 18,288 Form Controls!! I have no idea how, what or why.
Does anyone know how I can get to the bottom of this problem and delete Form Controls?
Thank you!

 

[tlc53]

Or if you want to delete unwanted checkboxes only ....

Amazing!! Thank you sooooo much!! The size of my file has gone down from 10,750KB to 670KB
Now I can fix all my other spreadsheets which have the same problem.
Thanks again

 

[Yongle]

all is good provided that you how so many checkboxes were created

 

[tlc53]

I would suggest to simply delete all shapes and recreate the one(s) you need as that is a lot faster than trying to delete the unneeded ones.

Thank you for this tip! It is proving very helpful in cleaning up my spreadsheets