How to Add Checkboxes in Excel
Excel 365 finally added native checkboxes in 2024 — click a cell, insert a checkbox, done. For older Excel versions there's the legacy Form Control checkbox from the Developer tab. This guide covers both.
⚡ Quick Answer
In Excel 365: select the cells, click Insert → Checkbox. Each cell now holds a checkbox storing TRUE or FALSE. For older Excel: enable Developer tab, then Developer → Insert → Form Controls → Checkbox.
Method 1: Native checkboxes (Excel 365)
Modern, cell-based checkboxes. The cell value is literally TRUE or FALSE.
Select the cells
Highlight the cells where you want checkboxes.
Click Insert → Checkbox
In the Cell Controls group of the Insert tab. Every selected cell gets a checkbox.
Click to toggle
Click any checkbox to check or uncheck. Cell value becomes TRUE or FALSE.
Native checkboxes ARE the cell value. They copy, paste, sort, filter, and reference like any other cell. Legacy Form Control checkboxes are floating objects that hover over cells — they don't move when you sort, don't copy naturally, and require linked cells to be usable in formulas. Native is dramatically easier.
Using native checkboxes in formulas
Since native checkboxes store TRUE/FALSE directly, formulas are simple:
=IF(A1, "Done", "Not done")
=COUNTIF(A2:A100, TRUE)
=SUMIF(A2:A100, TRUE, B2:B100)The first counts complete tasks. The second sums values in column B where the checkbox in column A is checked.
Method 2: Form Control checkboxes (older Excel)
For Excel 2021, 2019, or earlier without native checkbox support.
Enable the Developer tab
File → Options → Customize Ribbon
Open Excel options.
Tick Developer in the right panel
Click OK. The Developer tab appears in the ribbon.
Insert a Form Control checkbox
Click Developer → Insert
The Insert dropdown shows Form Controls and ActiveX Controls.
Click Checkbox (in Form Controls)
Cursor becomes a crosshair.
Draw the checkbox
Click and drag on the sheet where you want the checkbox to appear.
Right-click → Format Control → set Cell Link
Choose a cell to receive TRUE/FALSE when the checkbox toggles. Formulas reference this linked cell.
Copy-pasting a Form Control checkbox often copies the linked cell too — meaning all copied checkboxes toggle the same cell. You have to right-click each and re-set the Cell Link. For many checkboxes, native checkboxes (Excel 365) or VBA are much better.
Common use cases
To-do list
Column A: checkboxes. Column B: task descriptions. Formula in a summary cell: =COUNTIF(A2:A100, TRUE) to count completed tasks.
Conditional formatting based on checkbox
Select task rows → Home → Conditional Formatting → New Rule → Use a formula → =$A2=TRUE → set strikethrough or grey font. Checked tasks visually cross out.
Filter to unchecked items
Apply AutoFilter, click the checkbox column's filter arrow, tick only FALSE. Only incomplete tasks show.
Removing checkboxes
- Native checkbox: select the cell → Insert → Checkbox again (it toggles off). Or press Delete.
- Form Control: right-click the checkbox → Cut. Or click to select then press Delete.
Excel Wizard — turn checkboxes into workflows
Native checkboxes make todo lists trivial. But real workflows need "when checked, notify the manager" or "when all sub-tasks complete, mark parent done." Excel Wizard's AI can add those workflows through Office Scripts or Power Automate flows — auto-generated from natural-language descriptions of what you want to happen.
Install Excel Wizard →Frequently asked questions
How do I add a checkbox in Excel?
Excel 365 has native checkboxes: select the cells, click Insert → Checkbox. Every selected cell gets a checkbox that stores TRUE (checked) or FALSE (unchecked). For older Excel versions, use Developer tab → Insert → Form Controls → Checkbox, which places a separate checkbox object over cells.
Why don't I see the Checkbox option in the Insert menu?
Native checkboxes are only in Excel 365 (added in 2024). For Excel 2021, 2019, or earlier, use the Developer tab: File → Options → Customize Ribbon → tick Developer, OK. Then Developer → Insert → Form Controls → Checkbox. These older checkboxes are floating objects, not cell values.
How do I use a checkbox value in a formula?
Native Excel 365 checkboxes store TRUE/FALSE directly in the cell — reference them like any cell: =IF(A1, "Done", "Todo") or =COUNTIF(A2:A100, TRUE). Legacy Form Control checkboxes need a linked cell: right-click the checkbox, Format Control, set Cell Link to a cell — the linked cell then shows TRUE or FALSE.
How do I remove a checkbox in Excel?
For native Excel 365 checkboxes: select the cells and click Insert → Checkbox again (toggles off), or press Delete. For legacy Form Control checkboxes: right-click and choose Cut, or select the checkbox and press Delete.