How to Insert a Checkbox in Excel
Excel now has a real cell checkbox that returns TRUE or FALSE. Here is how to add it in Microsoft 365, plus the classic Developer method for older versions.
Excel has two ways to add a checkbox. In Microsoft 365 there is now a real cell checkbox that stores TRUE or FALSE right in the cell — select your cells and choose Insert, Checkbox. Older, perpetual versions need the classic Form Control from the Developer tab.
The native checkbox in Microsoft 365
Select the range where you want boxes, open the Insert tab, and choose Checkbox. Each cell gets a box you toggle with a click or the Spacebar, and the cell’s value becomes TRUE when checked and FALSE when unchecked. Because the value lives in the cell, you can use it in formulas straight away, such as =IF(A2,"Done","Pending"). This feature is in Excel for Microsoft 365 on Windows, Mac, and the web, but not in Excel 2021 or 2024. Deleting has one quirk: select the cells and press Delete. If a box is unchecked it disappears; if it is checked, the first Delete only unchecks it and a second press removes it.
| Method | Best for | Value in the cell |
|---|---|---|
| Native checkbox (365) | Checklists, percent complete | Real TRUE / FALSE |
| Form Control (all versions) | Older Excel, forms | Via a linked cell |
| ActiveX control | Macros only | Needs VBA — avoid |
The classic method for older versions
If you do not see Insert, Checkbox, turn on the Developer tab: File, Options, Customize Ribbon, and check Developer. Then choose Developer, Insert, and under Form Controls pick the Check Box. This one is a floating object, not a cell value, so right-click it, choose Format Control, open the Control tab, and set Cell link to a cell. That linked cell then shows TRUE or FALSE for formulas to read. Prefer Form Controls over ActiveX, which is Windows-only and needs VBA to do anything.
Turn checkboxes into a working checklist
Once boxes write TRUE and FALSE, you can count and format from them. Use =COUNTIF(B2:B20,TRUE) for completed items, and =COUNTIF(B2:B20,TRUE)/COUNTA(B2:B20) for percent done. A conditional-formatting rule like =$B2=TRUE can shade or strike through finished rows. If you are building a form for other people, pair the boxes with a drop-down list and locked cells so the layout survives being used. The same clickable box exists in Word — see inserting a checkbox in Word.
For anyone on Microsoft 365, the native cell checkbox is the one to use: it needs no linked cell and behaves like real data. Keep the Developer-tab method in mind only for spreadsheets that must open in Excel 2021 or earlier.