How to Use the New Excel Check Box Feature
The new Excel check box feature makes it easy to build interactive to-do lists, project trackers, and checklists right inside your spreadsheet. With a couple of clicks, any cell can become a check box that you tick on and off, and your formulas can respond to it instantly.
Check boxes are ideal wherever you need a visual record of completion: task lists, onboarding checklists, inspection sheets, packing lists, and project status trackers. They also make spreadsheets friendlier for people who do not want to type "Yes" or "Done" into cells.
This guide explains how to insert the new in-cell check boxes, how they work with formulas and conditional formatting, and how to build a to-do list with a progress tracker. It also covers the older Developer tab method for versions of Excel that do not have the new feature, and includes a free interactive tracker you can copy into Excel.
The New In-Cell Check Boxes
The new check boxes live inside cells rather than floating on top of the sheet. They are available in Excel for Microsoft 365 on Windows and Mac and in Excel for the web. They are not included in one-time-purchase versions of Excel, so if you do not see the option, use the Developer tab method described later.
How to Insert Check Boxes
Select the cell or cells where you want check boxes. If you need a whole column of them, select the entire range first. Then go to the Insert tab and, in the Cell Controls group, click Checkbox. That is it. Every selected cell now shows an unchecked box. This YouTube tutorial shows the steps in under a minute.
To check or uncheck a box, click it, or select the cell and press the spacebar. To check a whole range at once, select the cells and press the spacebar.
What a Check Box Really Is
Behind the scenes, each check box is simply a cell holding a TRUE or FALSE value. A checked box is TRUE, and an unchecked box is FALSE. Click the cell and look at the formula bar, and you will see the value.
That simple design is what makes the new check boxes so useful. Because the value lives in the cell itself, any formula can read it directly. If you already have a column of TRUE and FALSE values, selecting it and choosing Insert, Checkbox turns those values into checked and unchecked boxes.
Using Check Boxes in Formulas
If your check boxes are in column C, you can show a status label next to each one. In D2, type =IF(C2,"Done","In progress") and copy it down. Because C2 is already TRUE or FALSE, you do not even need to write C2=TRUE, although that works too.
To count completed items, use =COUNTIF(C2:C20,TRUE). To count open items, use =COUNTIF(C2:C20,FALSE). For percent complete, divide the checked count by the number of tasks: =COUNTIF(C2:C20,TRUE)/ROWS(C2:C20), formatted as a percentage. And to total something only for checked items, such as the hours for completed tasks, use =SUMIF(C2:C20,TRUE,E2:E20).
Removing Check Boxes
To remove a check box, select the cell and press Delete. If the box is checked, the first press unchecks it and the second removes it. You can also select the cells and use Home, Clear, then Clear Formats.
Why the New Check Boxes Are Better
Compared with the older method, the new check boxes are far easier to insert, especially when you need many in the same column or row. There is no drawing them in place, no deleting the default "Check Box 1" label, no lining them up, and no linking each one to a cell. They also sort, filter, copy, and fill down like any other cell value.
Free Check Box Task Tracker
The tracker below behaves exactly like a check box list in Excel. Tick tasks on and off and watch the cell value switch between TRUE and FALSE, the status formula update, completed rows cross themselves out, and the progress bar fill. It also shows which owner has the most open tasks.
Click Copy to Excel to paste the list with TRUE and FALSE values, live status formulas, and COUNTIF progress formulas. Then select the TRUE and FALSE column and choose Insert, Checkbox to turn it into real check boxes.
Check Box Task Tracker
Tick tasks off and watch the formulas behind Excel check boxes work: each box is simply TRUE or FALSE, and COUNTIF, IF, and conditional formatting turn those values into status labels, a progress bar, and crossed-out completed rows. Copy it to Excel, then turn the TRUE and FALSE column into check boxes in one click. Nothing you enter is saved or sent anywhere.
| Done | Task | Owner | Cell value | Status formula result |
|---|
Formulas: =IF(A2,"Done","In progress") for status, =COUNTIF(A2:A7,TRUE) for checked, =COUNTIF(A2:A7,TRUE)/ROWS(A2:A7) for percent complete, and the conditional formatting rule =$A2=TRUE for strikethrough.
Formatting Completed Rows Automatically
Check boxes become even more useful when completed items change appearance. To gray out and cross out finished tasks, select the task rows, for example A2:D20, then go to Home, Conditional Formatting, New Rule, and choose "Use a formula to determine which cells to format."
If the check boxes are in column C, enter =$C2=TRUE. The dollar sign locks the column so every cell in the row checks the same box. Click Format, choose strikethrough on the Font tab and a light gray fill, and click OK. Each row now updates the moment its box is checked. Our guide to mastering conditional formatting explains this whole-row technique in detail.
Building a To-Do List With Check Boxes
Putting it all together takes only a few minutes. List your tasks in column A, owners in column B, and select column C for the check boxes. Insert check boxes with Insert, Checkbox, add a status formula in column D, and apply the strikethrough rule above.
At the top, add a summary with the count of completed tasks and the percent complete. For a visual progress bar, apply a data bar to the percent cell from Conditional Formatting, Data Bars, and set its minimum to 0 and maximum to 1. Format the list as an Excel table with Ctrl + T so new tasks pick up the check boxes, formulas, and formatting automatically. Our Excel project tracker template takes the same idea further.
The Developer Tab Check Box Method
If your version of Excel does not include the new check boxes, you can still use the older Form Control check boxes. They take more setup, but they work in every desktop version.
Step 1: Enable the Developer Tab
Go to File, then Options, and select Customize Ribbon. In the list on the right, check the box next to Developer and click OK. The Developer tab now appears on the ribbon. Our guide to the Excel Developer tab covers its other tools.
Step 2: Insert a Check Box
On the Developer tab, click Insert in the Controls group, and under Form Controls choose the Check Box icon. Your cursor becomes a crosshair. Click in the cell where you want the check box, then drag its edges to resize or reposition it. Right-click it and choose Edit Text to delete the default label.
Step 3: Link the Check Box to a Cell
A Form Control check box floats on top of the sheet, so it needs a linked cell to store its value. Right-click the check box, choose Format Control, go to the Control tab, and in the Cell link box enter a cell, such as $D$2. Click OK. Now the linked cell shows TRUE when the box is checked and FALSE when it is not, and your formulas and conditional formatting can refer to that linked cell.
Step 4: Repeat for Each Check Box
Each Form Control check box must be linked individually. Copying a check box down a column keeps the original link, so update the Cell link for each copy. This is the main reason the new in-cell check boxes are so much faster.
Practical Uses for Check Boxes
Check boxes work anywhere you track completion or yes and no answers. Common examples include daily task lists and team to-do lists, onboarding checklists for new employees, safety and equipment inspection sheets, event planning and packing lists, attendance or sign-off sheets, and project milestone trackers. Because they are simply TRUE and FALSE values, you can summarize them with COUNTIF, filter to see only open items, and chart progress over time.
From Checklists to Task Management
Check box lists are perfect for personal tasks and small projects. When a whole team shares tasks with owners, deadlines, and recurring checklists, Updoot is business management software that tracks tasks, projects, SOP checklists, and time in one place for $5 per user per month. You can start a free trial anytime.
Final Thoughts
The new Excel check box feature turns any cell into an interactive TRUE or FALSE control in seconds. Insert them from Insert, Checkbox, use them directly in IF, COUNTIF, and SUMIF formulas, and pair them with conditional formatting to cross off completed work automatically. If your version does not have the new feature, the Developer tab method still works with a little more setup. Either way, check boxes make your spreadsheets more interactive, more visual, and easier for everyone to use. Happy Excelling!
Opens in Google Drive. View and download for free.
Frequently Asked Questions About Excel Check Boxes
How do I insert a check box in Excel?
Select the cells, go to the Insert tab, and click Checkbox in the Cell Controls group. In versions without that option, use Developer, Insert, Form Controls, Check Box.
What value does an Excel check box store?
A checked box is TRUE and an unchecked box is FALSE. With the new in-cell check boxes, the value is stored in the cell itself, so formulas can use it directly.
How do I count checked boxes in Excel?
Use =COUNTIF(C2:C20,TRUE) to count checked boxes and =COUNTIF(C2:C20,FALSE) to count unchecked ones.
How do I cross out a row when a box is checked?
Select the rows, create a conditional formatting rule using a formula such as =$C2=TRUE, and choose strikethrough and a light fill as the format.
Why don't I see the Checkbox option on the Insert tab?
The in-cell check boxes are available in Excel for Microsoft 365 and Excel for the web, not in one-time-purchase versions. Use the Developer tab Form Control check box instead.
How do I remove a check box in Excel?
Select the cell and press Delete. If the box is checked, the first press unchecks it and the second removes it.
Can I check several boxes at once?
Yes. Select the cells and press the spacebar to toggle all of them.