Build a Boolean Input Checklist with In-Cell Checkboxes in Excel

Quick answer: Select the input cells and choose Insert > Checkbox. Checked cells contain TRUE and unchecked cells contain FALSE, so formulas can refer directly to those cells. These are modern in-cell checkboxes, not Developer Form Controls with separate linked-cell properties.

Scope and setup

Use English Excel for Microsoft 365 desktop on Windows with Insert > Checkbox available. Microsoft’s source also lists Microsoft 365 for Mac, but the instructions here use the Windows interface. No support is claimed for Excel 2013, 2016, 2019, 2021, 2024, web, or mobile, and no minimum numeric build is inferred. If the command is missing, do not substitute legacy controls and assume they have the same behavior.

Start a new XLSX workbook. Enter these cells:

Row	A: Task	B: Done	C: Status
1	Task	Done	Status
2	Check headings	leave blank	formula below
3	Reconcile totals	leave blank	formula below
4	Review labels	leave blank	formula below
5	Save workbook	leave blank	formula below

The explanatory text “leave blank” and “formula below” is not cell content. A1:C1 contains the three headings, A2:A5 the four task names, and B2:C5 initially remains empty. Keep input cells and result formulas visibly separate.

Insert and connect the inputs

1. Select B2:B5 and choose Insert > Checkbox. The new unchecked inputs represent FALSE.
2. In C2 enter =IF(B2,"Done","Pending") and fill it down through C5. Relative references should become B3, B4, and B5.
3. In E1 enter Completed and in E2 enter =COUNTIF(B2:B5,TRUE).
4. In F1 enter Remaining and in F2 enter =4-E2.

Initially every Status should be Pending, E2 should be 0, and F2 should be 4. There is no separate linked-cell configuration to perform: the Boolean value is in the checkbox cell itself. See IF for the status expression.

Toggle and independently check

Click B2 to check the first task, then select B4 and press Spacebar to check the third. C2 and C4 should say Done; C3 and C5 remain Pending. E2=2 and F2=2.

Now select B3 and press Spacebar. The completed count becomes 3 and remaining becomes 1. Press Spacebar again on B3 to return to two completed tasks. Check the formula references if the wrong status changes. A formula reading B2 in every row would produce a plausible-looking but incorrect checklist.

Keep these checks tied to the known four-row fixture. If you extend the list later, extend the checkbox and formula ranges and replace the fixed 4 with an appropriate total-task calculation. Appending text beneath the table does not automatically make B2:B5 include it.

Remove without confusing state and formatting

Save the intact checklist as Checklist-main.xlsx with B2 and B4 checked, E2=2, and F2=2. Close and reopen that main file to verify those states, then save a separate Checklist-removal-test.xlsx copy for the following removal tests. Select checked B2 and press Delete: the first press unchecks it, leaving a FALSE checkbox. Press Delete again while it is unchecked to remove that unchecked checkbox. This two-stage behavior is why a single Delete is not a reliable “remove every checkbox” operation when states differ.

For a value-preserving removal test, first check B4. Select B4 and choose Home > Clear > Clear Formats. The checkbox formatting is removed, along with other cell formatting, but its TRUE value remains. C4 should still show Done because it depends on the Boolean, not the visual box. Do not confuse Clear Formats with clearing the cell contents.

Save and verify persistence

Close Checklist-removal-test.xlsx and reopen the saved Checklist-main.xlsx. Verify that B2 and B4 remain checked, C2 and C4 say Done, E2=2, and F2=2; this is a reader validation step, not a claimed native test. If another Excel version cannot display interactive checkboxes, do not promise identical behavior. Preserve explicit TRUE/FALSE values and formula logic, and use a supported Microsoft 365 desktop client when interactive checkbox input is required.

Official references

• Using check boxes in Excel