You can insert a checkbox in Excel with one click, Insert > Checkbox, and each box is a real TRUE/FALSE value that formulas can read. This guide covers how to add them, tick them, use them in formulas and delete them. Delete behaves oddly the first time.
Check your Excel version first
As of November 2026, the "Applies To" line on Microsoft's checkbox help page lists only Excel for Microsoft 365 and Excel for Microsoft 365 for Mac. Older versions need a different method, which this guide does not cover. Everything here relies on the native in-cell checkbox.
Insert checkboxes into a range of cells
- Select the cells where you want checkboxes. One cell works, and so does a whole column of tasks.
- Go to the Insert tab.
- Click Checkbox.
Excel puts a checkbox in every cell you selected, per Microsoft. You don't have to draw or align anything, because the box lives inside the cell.
Tick a box and read its TRUE/FALSE value
Click a checkbox to tick or untick it. To toggle several at once, select them and press Spacebar.
A checked box is TRUE and an unchecked box is FALSE. Microsoft describes a checkbox as those values with checkbox formatting applied. Any formula pointing at the cell gets TRUE or FALSE. Here is Microsoft's own example, with a checkbox in A1:
=IF(A1, "Checked", "Unchecked")
The condition is already TRUE or FALSE, so you don't need to write A1=TRUE.
A checkbox is a good fit for a simple yes/no. If you'd rather pick a status like "In progress" or "Blocked", use a drop-down list with Data Validation. To pull unfinished tasks into a separate list, see FILTER with conditions.
Delete checkboxes: why the first Delete only unticks them
This catches most people. Select the cells and press Delete. According to Microsoft, one of two things happens:
- If every checkbox in the selection was unchecked, they are removed.
- If any were checked, they all become unchecked instead, and the boxes stay.
Press Delete a second time to remove them. If the boxes seem stuck, you probably just need that second press.
Keep the TRUE/FALSE values but drop the checkbox look
Sometimes you want the data without the boxes, for example before sending a sheet to someone on an older Excel. Select the cells and choose Home > Clear > Clear Formats. The cells keep their TRUE and FALSE values.
Microsoft warns that this also removes all other formatting from those cells, so apply it only to the checkbox cells.
Insert > Checkbox is missing: what to check
If you can't find Checkbox on the Insert tab, the usual reason is your version. Microsoft's page names only the two Microsoft 365 apps, for Windows and Mac. Check which Excel you're running against that Applies To line.
Microsoft's page doesn't say whether Excel on the web or the mobile apps support in-cell checkboxes. If you rely on them there, look at the menu in that app first.
