Checkboxes are a versatile feature in Excel, useful for making interactive lists and forms. In this article, we'll cover how to add, remove, and toggle them.
To insert Checkboxes:
-
Select the range where you want checkboxes.
-
Select Insert > Checkbox.
Removing Checkboxes
To remove checkboxes:
-
Select the range of cells with the checkboxes you want to remove.
-
Press the Delete key. If all of the Checkboxes were unchecked, they will be removed, otherwise they will become unchecked (now you can press Delete again to remove them).
Toggling Checkboxes
To check or uncheck a Checkbox:
-
Click on the checkbox.
-
Select one or more checkboxes and press Space.
Checkboxes have the value TRUE or FALSE
A Checkbox is composed of the values TRUE and FALSE with Checkbox formatting.
-
A checked Checkbox has the value TRUE.
-
An unchecked Checkbox has the value FALSE.
If you reference a Checkbox cell with a formula, TRUE or FALSE will be passed along to that formula.
For example, if you have a Checkbox in cell A1, you can use a formula like =IF(A1, "Checked", "Unchecked") to display a custom message based on the Checkbox's state.
To remove Checkbox formatting (and all other formatting) while retaining their values:
-
Select the range of cells with the checkboxes you want to remove.
-
Select Home > Clear > Clear Formats.
