Excel checkboxes are useful for trackers, to-do lists, forms, approvals, and dashboards. Newer Microsoft 365 builds include a simple cell checkbox; older versions use the Developer tab control.
Does this affect you?
Use this for Microsoft 365 on Windows or Mac if you see the one-click Checkbox command. For Excel 2021, Excel 2019, and earlier, use the Developer tab method.
Insert a checkbox the fast way
Try this first in current Microsoft 365.
- Select the cell or cells where checkboxes should appear.
- Open the Insert tab.
- Look for Checkbox in the Cells or Controls area.
- Click Checkbox.
- Click a box to toggle it on or off.
The cell value becomes TRUE when checked and FALSE when unchecked, so formulas like =COUNTIF(A2:A20,TRUE) can count completed items.
Insert a checkbox with the Developer tab
This classic method works in older desktop versions too.
- If Developer is hidden, open File > Options > Customize Ribbon, check Developer, and click OK.
- Open Developer > Insert.
- Under Form Controls, choose the checkbox icon.
- Click and drag on the worksheet to draw the checkbox.
- Right-click the checkbox and choose Edit Text to change or remove the label.
- Right-click and choose Format Control, then set Cell link on the Control tab if formulas need TRUE/FALSE output.
- Copy and paste the checkbox to other rows, updating each linked cell.
More control
Use linked cells for formulas
A visual checkbox is most useful when it writes TRUE or FALSE to a linked cell. Use that linked value in COUNTIF, filters, conditional formatting, or dashboard formulas.
Older versions do not get the new checkbox
Excel 2021, Excel 2019, and earlier perpetual versions use the Developer method. The modern cell checkbox is a Microsoft 365 feature.
Sources
- Microsoft Support – Insert a checkbox in Excel (2025)
- Microsoft Support – Create a checklist in Excel (2025)
- Microsoft Support – Show the Developer tab (2024)