Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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.

A short list of chores with checkboxes beside them

To insert Checkboxes:

  1. Select the range where you want checkboxes.

  2. Select Insert > Checkbox.

The Insert Checkbox button on the Insert tab

Removing Checkboxes

To remove checkboxes:

  1. Select the range of cells with the checkboxes you want to remove.

  2. 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:

  1. Select the range of cells with the checkboxes you want to remove.

  2. Select Home > Clear > Clear Formats.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!