How to Insert a Checkbox in Excel: Two Easy Methods

In supported versions of Excel for Microsoft 365, select the cell or range and choose Insert > Checkbox. These in-cell checkboxes store TRUE or FALSE in the cell, so formulas can use them directly.

If that command is missing, desktop Excel offers a legacy Form Control checkbox. It floats over the grid and can write its state to a linked cell.

Microsoft lists the in-cell feature for Excel for Microsoft 365 and Microsoft 365 for Mac. See Microsoft's checkbox guide for supported steps.

Insert an in-cell checkbox in Excel

Use column A for tasks and column B for checkboxes. The same layout works for attendance, with names in A and a Present column in B.

1. Set up the worksheet. Enter Task in A1 and Done in B1. Add tasks in A2:A6 and reserve B2:B6 for the boxes, so labels remain readable.

   

2. Select the checkbox cells. Select B2:B6, leaving out the header. Selecting one cell adds one box; selecting a range adds a box to each selected cell.

   

3. Insert the boxes. Choose Insert > Checkbox. Excel adds a box to each selected cell. If Checkbox is missing, your build may not include the feature; try the Form Control method below.

   

4. Check that each cell has a box. Each checkbox belongs to its cell rather than floating above the grid. Checked cells evaluate to TRUE, and unchecked cells to FALSE; formulas can read either value.

   

5. Mark items complete. Click a box to toggle it, or select one or more checkbox cells and press the Spacebar to change them from the keyboard.

   

6. Count completed or remaining items. To count checked boxes, enter =COUNTIF(B2:B6,TRUE). Use =COUNTIF(B2:B6,FALSE) for unchecked boxes. The totals update when a box is toggled. If your regional settings use semicolons, replace the formula commas with semicolons.

   

To turn a checkbox into text, use =IF(B2=TRUE,"Present","Absent") and fill the formula down. See Microsoft's COUNTIF reference for the function syntax.

Use a Developer Form Control checkbox

Use Form Controls in desktop Excel when the in-cell command is unavailable or you need a floating object. These steps describe Windows; menus can vary by release. Microsoft lists Form Controls for Microsoft 365, Excel 2024, 2021, 2019, and 2016.

1. Show the Developer tab. Choose File > Options > Customize Ribbon, check Developer under Main Tabs, and select OK. This enables the tab for the installation.

   

2. Choose the checkbox control. Open Developer > Insert, choose the checkbox under Form Controls, then click the worksheet to place it.

   

3. Edit its label and placement. This checkbox is a floating object, not part of a cell. Edit or remove its default label and position it in the row. Microsoft says Form Controls are added one at a time, though you can copy a control to speed up a long list.

   

4. Link the control to a cell. Right-click the checkbox and choose Format Control. On Control, enter $H$2 in Cell link and select OK. The linked cell exposes the checkbox state to formulas.

   

5. Use the linked value. Use =IF(H2=TRUE,"Present","Absent") in a status cell. A checked control returns Present; a cleared one returns Absent. For multiple rows, link each control to its own cell, such as H2:H6, and reference the matching row.

   

6. Summarize the list. Count checked controls with =COUNTIF(H2:H6,TRUE). After copying a control, confirm its Cell link points to the right row. See Microsoft's Developer tab guide and Form Controls guide.

   

Which method should you choose?

Use in-cell checkboxes for simple trackers: their TRUE/FALSE values are already in the cells. Use Form Controls for a floating object or older desktop version. Form Controls cannot be used in Excel for the web; Microsoft warns that continuing to edit a workbook in the browser after an unsupported-features prompt can remove them. Open it in desktop Excel to preserve the controls.