Check boxes 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.
Insert check boxes
-
Select the range where you want check boxes.
-
Select Insert > Checkbox.
Remove check boxes
-
Select the range of cells with the check boxes you want to remove.
-
Select the Delete key. If all of the check boxes were unchecked, they will be removed, otherwise they will become unchecked (now you can select Delete again to remove them).
Toggling check boxes
To check or uncheck a check box:
-
Click on the check box.
-
Select one or more check boxes and select Spacebar.
Check boxes have the value TRUE or FALSE
A check box is composed of the values TRUE and FALSE with checkbox formatting.
-
A checked check box has the value TRUE.
-
An unchecked check box has the value FALSE.
If you reference a check box cell with a formula, TRUE or FALSE will be passed along to that formula.
For example, if you have a check box in cell A1, you can use a formula like =IF(A1, "Checked", "Unchecked") to display a custom message based on the check box's state.
To remove check-box formatting (and all other formatting) while retaining their values:
-
Select the range of cells with the check boxes you want to remove.
-
Select Home > Clear > Clear Formats.
