How to Insert Checkboxes in Microsoft Excel

Interactive checklists, project milestones, task sign-offs, and quality assurance audits are much easier to manage when users can simply click a box to mark an item complete. In modern releases of Microsoft Excel, inserting functional checkboxes is straightforward, allowing you to link tick boxes directly to logical formulas, conditional formatting rules, and dynamic progress bars.

Two Ways to Insert Checkboxes in Excel

Depending on your current version of Microsoft Excel, you can insert checkboxes using either:

  • Cell-Native Checkboxes (Modern Excel 365): Checkboxes reside directly inside cells as values (TRUE / FALSE), enabling seamless sorting and formula calculations.
  • Form Control Checkboxes (Classic / Desktop Excel): Floating form controls placed via the Developer tab that link to specific cell references.

Method 1: Using Modern Cell-Native Checkboxes (Excel 365)

In modern Excel 365 and Excel for the Web, adding checkboxes takes seconds without enabling developer tools:

  1. Open your spreadsheet and select the cells where you want checkboxes to appear (for example, range A2:A10).
  2. Click on the Insert tab on the Excel ribbon.
  3. In the Cell Controls group, click on Checkbox.

Clean checkboxes will appear immediately inside each highlighted cell. Clicking a checkbox toggles it between checked (TRUE) and unchecked (FALSE).

Tip: Because modern checkboxes are native cell values, you can calculate the number of completed tasks using a simple formula: =COUNTIF(A2:A10, TRUE).

Method 2: Using Form Control Checkboxes via the Developer Tab

If you are running an older desktop version of Excel without the native Checkbox button on the Insert tab:

  1. Enable the Developer tab if it is not visible: Go to File > Options > Customise Ribbon, check the box next to Developer in the right-hand list, and click OK.
  2. On the Developer tab, click Insert in the Controls group.
  3. Under Form Controls, click the Check Box (Form Control) icon.
  4. Click on the worksheet where you want to position the checkbox.
  5. Right-click the checkbox, click Edit Text to delete or change the default label, and resize the control border.
  6. Right-click the control, select Format Control, navigate to the Control tab, and set a Cell link (for example, $B$2). Click OK.

Creating Dynamic Formatting with Checkboxes

To automatically apply strikethrough styling and grey out task names when a checkbox is ticked:

  1. Highlight your task descriptions (e.g. B2:B10).
  2. Go to Home > Conditional Formatting > New Rule.
  3. Select Use a formula to determine which cells to format.
  4. Enter =A2=TRUE as the formula.
  5. Click Format, check Strikethrough, choose a grey font colour, and click OK.

Combining interactive checkboxes with conditional formatting transforms standard spreadsheets into intuitive, professional project management tools.

Get the best tech tips delivered straight to your inbox.

Join thousands of readers mastering Apple, Google, Microsoft, and Linux.