Checkboxes in Excel: How to Insert Them and Use Them in Formulas

Checkboxes in Excel task tracker with ticked and unticked Done column

Checkboxes in Excel are now a built-in cell feature, not a fiddly form control. Select a range, choose Insert > Checkbox, and every cell gets a clickable box that stores TRUE when ticked and FALSE when cleared, ready to use in formulas, conditional formatting, and dashboards.

This guide covers where the feature is available, how to insert, toggle, and remove checkboxes, and six formulas that turn a simple list into a working task tracker. A free practice workbook with the same data is linked at the end.

Where Can You Use Checkboxes in Excel?

Microsoft released in-cell checkboxes in mid-2024. According to the Microsoft Excel blog announcement (updated January 2026), they are fully rolled out on these platforms:

PlatformAvailable?Notes
Excel for Microsoft 365 (Windows)YesCurrent, Monthly Enterprise, and Semi-Annual channels
Excel for Microsoft 365 (Mac)YesInsert tab
Excel for the webYesWorks in the browser
Excel for iPad, iPhone, and AndroidYesTap a box to toggle it
Excel 2024, 2021, 2019 (one-time purchase)NoUse the Developer tab check box form control instead

How to Insert Checkboxes in Excel

  1. Select the cells where you want checkboxes, for example E2:E9.
  2. Go to Insert > Checkbox (in the Cell Controls group).
  3. Every selected cell now shows an unchecked box with the value FALSE.

If the cells already contain typed TRUE or FALSE values, they appear as checked or unchecked boxes right away. Checkbox formatting only applies to these logical values and blank cells; text and numbers are left as they are.

Toggle, Remove, and Keep the Values

  • Toggle: click a box, or select several and press Spacebar.
  • Remove: press Delete. If any boxes were ticked, the first Delete unticks them and the second removes them.
  • Remove boxes but keep TRUE/FALSE: use Home > Clear > Clear Formats.
  • Copy: checkboxes copy, paste, and fill down like any other cell value.

These steps match the official Microsoft guide to using check boxes in Excel.

Sample Task Tracker Data

The formulas below use this event-planning tracker in A1:E9. Column E holds the checkboxes.

TaskOwnerDueCostDone
Book venuePriya18-Nov-202645,000TRUE
Send invitesArjun19-Nov-20262,500TRUE
Confirm catererMeera21-Nov-202660,000FALSE
Print badgesArjun23-Nov-20264,800FALSE
Arrange AV setupKabir24-Nov-202618,000TRUE
Order gift kitsPriya25-Nov-202622,000FALSE
Test live streamKabir26-Nov-20263,500FALSE
Share agendaMeera27-Nov-20261,200TRUE

6 Formulas That Use Checkboxes in Excel

1. Count completed tasks

=COUNTIF(E2:E9, TRUE)

Returns 4. Change TRUE to FALSE to count open tasks.

2. Show percent complete

=COUNTIF(E2:E9, TRUE)/COUNTA(A2:A9)

Returns 50% when formatted as a percentage. Tick another box and it jumps to 62.5% instantly.

3. Sum the cost of finished tasks

=SUMIFS(D2:D9, E2:E9, TRUE)

Returns 66,700 (45,000 + 2,500 + 18,000 + 1,200). Use FALSE to get the remaining spend of 90,300.

4. List pending tasks with FILTER

=FILTER(A2:A9, NOT(E2:E9), "All done")

Spills Confirm caterer, Print badges, Order gift kits, and Test live stream. As you tick boxes the list shrinks. If the result is blocked, see how to fix the #SPILL! error in Excel.

5. Count done tasks per owner

=COUNTIFS(B2:B9, "Priya", E2:E9, TRUE)

Returns 1: Priya has finished Book venue but not Order gift kits.

6. Check that every box in a row is ticked

For an onboarding checklist with Laptop, Email, and Training checkboxes in B2:D2, this returns TRUE only when all three are ticked:

=AND(B2:D2)

You can even insert a checkbox over this formula cell. Because the value comes from a formula, the box is read-only and ticks itself when the row is complete.

Strike Through Completed Tasks

Select A2:E9, open Home > Conditional Formatting > New Rule, choose Use a formula to determine which cells to format, enter =$E2=TRUE, and set a strikethrough font with grey colour. Our tutorial on conditional formatting in Excel explains the rule dialog in detail.

In-Cell Checkboxes vs Form Controls vs Google Sheets

FeatureExcel in-cell checkboxDeveloper tab check boxGoogle Sheets checkbox
Lives in the cellYesNo, floats on topYes
ValueTRUE / FALSE in the cellNeeds a linked cellTRUE / FALSE or custom values
Insert many at onceYesNo, one at a timeYes
Sorts and filters with dataYesNoYes
MenuInsert > CheckboxDeveloper > InsertInsert > Checkbox

Google Sheets also lets you set custom checked and unchecked values through data validation, as described on the Google Sheets checkbox help page. The formulas in this post work the same way in Sheets when you keep the default TRUE/FALSE values.

FAQ

Why is there no Checkbox button on my Insert tab?

You are probably on Excel 2021 or 2019, or a Microsoft 365 build that has not updated. Go to File > Account > Update Options > Update Now.

Can I count checkboxes with SUM?

Not directly, because SUM ignores logical values in ranges. Use COUNTIF(range, TRUE) or =SUM(--E2:E9).

What happens if someone opens the file in Excel 2019?

Older versions show the underlying TRUE and FALSE values instead of boxes, and formulas that reference them keep working.

Download the Practice Workbook

Use the companion workbook linked below to build this task tracker yourself. It has an Instructions sheet, a Practice sheet with the tracker and empty answer cells, and a Solutions sheet with working formulas.

Download the practice workbook

The same data as this tutorial, with empty answer cells and a Solutions sheet.

Team Xl in Excel

Team Xl in Excel

Spreadsheet Architect & Educator at Xl in Excel. Sharing advanced formulas, dynamic arrays, and clean data modeling techniques.

Learn More About Team Xl in Excel →

Leave a Reply

Your email address will not be published. Required fields are marked *

Zoom: 100% | UTF-8 | Xl in Excel