SS Checkboxes

Add Checkbox

Excel

Google Sheets

NOTE: Adding checkboxes in Excel relies on having the Developer tab visible in your ribbon. To add it, [right-click] on any other tab and "Customize the Ribbon..." then click "Developer" in the Main Tabs pane.
Use [Ctrl]-[right-click] to select the checkbox, drag it around, resize etc.Use [right-click] and select "Edit Text" to delete or change the caption name.

Delete Checkbox

To delete the checkboxes you have created, hold down [Ctrl], click all checkboxes to be deleted and hit [Del] or [backspace].


In my version (2208) of Excel it seems necessary to repeat this excercise more than once and not all checkboxes are deletd on the first attempt.

You may find it easier to delete via the "Selection Pane" in "Editing" - "Find & Select". Select and delete the named check boxes in the same way as above....

For hundreds of checkboxes you can also try...

Use the "Selection Pane" above to confirm that the only objects in your sheet are checkbox objects. If they are, then use "Editing" - "Find & Select" - "Go To Special". In the pop up box, choose "Objects" and click OK to select all checkboxes (then hit [Del] to delete them)...

If you need to be more selective you can drag the mouse to select the range containing checkboxes using "Editing" - "Find & Select" - "Select Objects"

If all else fails, resort to VBA... "Developer" - "Visual Basic", "Insert" - "Module"...

Sub RemoveCheckboxes()

On Error Resume Next

ActiveSheet.CheckBoxes.Delete

Selection.FormatConditions.Delete

End Sub

Bibliography