How to Insert a Checkbox in Excel (2026)
Checkboxes turn a column into a clickable to-do list or yes/no tracker. There are two ways to add them: the new built-in Checkbox in Microsoft 365 (simple, lives in the cell) and the classic form control (works in older versions, needs the Developer tab). Here’s both.
1. The New Way (Microsoft 365)
If you’re on a current version of Microsoft 365, Excel has a native checkbox:
- Select the cell or range where you want checkboxes.
- Go to the Insert tab and click Checkbox.
- A checkbox appears in each selected cell. Click one to toggle it.
A checked box stores TRUE in the cell and an unchecked box stores FALSE — so you can use the cell directly in formulas with no extra setup.
To remove them, select the cells and press Delete.
2. The Classic Way (Developer Tab)
On older versions (or for more control), use a form control. First, turn on the Developer tab:
- File > Options > Customize Ribbon.
- In the right column, check Developer, then click OK. (On Mac: Excel > Preferences > Ribbon & Toolbar > check Developer.)
Then insert the checkbox:
- Developer tab > Insert > under Form Controls, click the Checkbox.
- Click on the worksheet where you want it.
- Right-click the checkbox > Edit Text to rename or clear its label.
3. Link a Classic Checkbox to a Cell
A form-control checkbox doesn’t return a value until you link it:
- Right-click the checkbox > Format Control > Control tab.
- In Cell link, enter a cell (e.g.,
C2). - Click OK.
Now that cell shows TRUE when checked and FALSE when unchecked — ready for formulas.
4. Count Checked Boxes
Once boxes feed TRUE/FALSE into cells, count completed items with:
=COUNTIF(C2:C20, TRUE)Or show progress as a fraction with =COUNTIF(C2:C20, TRUE)&"/"&COUNTA(B2:B20).
5. Copy a Checkbox Down a Column
- 365 checkboxes: select the cells with checkboxes and drag the fill handle, or copy/paste down a range.
- Classic controls: copy the checkbox, then paste — but each linked cell must be updated individually, which is why the 365 checkbox is far easier for lists.
6. Troubleshooting
There’s no Checkbox button on the Insert tab
You’re not on a recent Microsoft 365 build. Update Office, or use the Developer-tab form control instead.
The checkbox doesn’t return TRUE/FALSE
That’s a classic form control without a Cell link. Right-click > Format Control > set the Cell link. (The 365 checkbox needs no linking.)
I keep selecting the checkbox instead of clicking it
For form controls, hold Ctrl and click to select (to move or edit) rather than toggle.
Mac and Web
The 365 Insert > Checkbox works on Mac and Excel for the web. Classic form controls require the desktop app.
Related Excel guides: How to create a drop-down list · How to use the IF function · How to use conditional formatting · How to lock cells · How to use SUMIF
Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
Get Carly Today →Or explore our free tools
