Forum Discussion
REMOVE A CHECKBOX FROM EXCEL WORKSHEET
I was handed an Excel worksheet that has three checkboxes that I wish to remove but cannot seem to remove them. Excel Help says to right click the Box and then hit Delete. There is no Delete in the...
I had the same issue and couldn't remove the check box using the methods above, then I found this:
Go to the Home tab > Editing group > Find & Select > Go To Special, select the Objects radio button, and click OK. This will select all the check boxes on the active sheet, and you simply press the Delete key to remove them.
This will remove all check boxes.
Many thanks Dennis! My clumsy workaround was to copy and paste the contents of the checkbox workbook into a new workbook and then delete the one with those pesky persistent checkboxes. Not nearly as efficient and elegant as your solution!