Checklist in Excel: Add Checkboxes and Track Tasks

How-to basics · Updated November 22, 2026

To add a checklist in Excel for Microsoft 365 on Windows, select the cells where you want checkboxes, then choose Insert > Checkbox. Each checkbox stores a TRUE or FALSE value in its cell, so you can count completed items, calculate progress, and use the result in other formulas.

How Excel checkboxes work

The current checkbox option is a cell feature: the checkbox appears inside a worksheet cell, and its checked state is the cell’s Boolean value. A checked box is TRUE; an unchecked box is FALSE. That makes these checkboxes easier to use in formulas than a picture or a symbol typed into a cell. You can click the box to change its state, and other worksheet features can refer to the cell.

This is different from older checkboxes that were inserted as floating controls on top of the sheet. Those controls can be moved independently of cells and may need a linked cell to expose their checked state to formulas. If you see references to the Developer tab, Form Controls, or ActiveX controls, those instructions usually describe the older approach rather than the newer in-cell checkbox.

The Insert checkbox command is available in current Microsoft 365 versions, but features can depend on the app and update channel. If the command is missing, check that Excel is updated and that you are using a version that supports in-cell checkboxes. Excel for Mac and Excel for the web may arrange or expose features differently from Windows, so look for Checkbox on the Insert tab rather than assuming the Windows ribbon layout is identical.

Add checkboxes to a worksheet

  1. Enter the checklist items in a column, such as task names in A2:A10.
  2. Select the blank cells beside the tasks, such as B2:B10.
  3. On the ribbon, choose Insert > Checkbox. Excel inserts a checkbox in each selected cell.
  4. Click a checkbox to mark its task complete. Click it again to clear it.

Selecting a range before inserting is the quickest way to make a group of checkboxes. You can also select one cell and insert a single checkbox, then copy that cell to other rows. If you copy a checked box, the copied cell may also carry its checked state; clear the copied boxes if you want every new task to start unchecked.

For a tidy layout, give the columns clear headings, for example Task and Done. Adjust column widths so the task text is readable and the checkbox column is compact. If the sheet contains several separate lists, add a heading for each group and leave a blank row between sections.

Build a useful task checklist

A checklist is easiest to maintain when the task description and its checkbox occupy separate columns. For example, put “Send the meeting notes” in A2 and its checkbox in B2. Keep one task per row, and avoid merging cells across the list: merged cells can make sorting, filtering, and copying ranges harder.

For a project list, you might include columns for task, owner, due date, and done. Place the checkboxes in the done column. Convert the range to an Excel table with Home > Format as Table if you want consistent formatting and filter controls as the list grows. Keep the checkbox cells aligned with their task rows when sorting; select or sort the complete table rather than sorting only the checkbox column, or tasks could become matched with the wrong completion states.

Checkboxes are useful for shopping lists, packing lists, review steps, maintenance logs, and simple project tracking. They are not a replacement for a full task-management system: a checked box records completion, but does not by itself store who completed the task, when it was completed, or why it was delayed. Add separate columns when that information matters.

Count completed items and calculate progress

Because the checkbox cells contain TRUE or FALSE, Excel formulas can summarize a list without manually counting marks. With checkboxes in B2:B10, this formula counts how many are checked: =COUNTIF(B2:B10,TRUE). If six of the nine boxes are checked, the result is 6. The range must contain the checkbox cells, not the task descriptions.

To calculate the proportion of tasks completed, assume task names are in A2:A10 and checkboxes are in B2:B10. Use =COUNTIF(B2:B10,TRUE)/COUNTA(A2:A10). If all nine task-name cells are filled and six boxes are checked, the result is 0.6667, or 66.67% when the result cell is formatted as a percentage. The COUNTA part counts nonblank task names, which helps avoid treating unused rows as tasks.

For a status label beside each task, assume the checkbox for the first task is in B2 and the status formula goes in C2. Enter =IF(B2,"Done","To do"), then fill the formula down. A checked box returns Done; an unchecked box returns To do. If you add tasks beyond row 10, extend the formula and summary ranges or use an Excel table so the list can expand more conveniently.

These formulas rely on the Boolean values in the new checkbox cells. A legacy Form Control checkbox is a separate object, so a formula generally needs to refer to the linked cell configured for that control instead of the object itself.

Make the checklist easier to read

Use simple formatting to show what matters without obscuring the checkboxes. Bold the header row, freeze it if the list is long, and use a restrained fill color for section headings. You can also use Excel’s conditional formatting to change the appearance of task text when its corresponding box is checked. For example, strike-through text or a muted font can make finished tasks less prominent while keeping them visible for reference.

When applying formatting, select the task cells and create a rule based on the matching checkbox column. Keep the row reference relative so the rule follows each task, and keep the checkbox column fixed if the formatting spans several columns. Test the rule on one checked and one unchecked row before applying it to the full list. If the task disappears entirely when completed, readers may lose useful context or mistake it for a deleted item.

For a progress indicator, place the completion formula in a summary cell above or beside the list and format it as a percentage. A label such as “6 of 9 complete” can be clearer than a percentage alone, especially for short lists. Make sure the total excludes blank rows; otherwise the displayed progress can look lower than it really is.

Modern checkboxes versus legacy controls

Use the in-cell checkbox when you want a straightforward checklist whose states work naturally with formulas, copying, and worksheet data. It stays in the cell grid and does not require a separate linked cell. This is usually the simplest choice for a new workbook made in a current Microsoft 365 version.

Legacy Form Control checkboxes can still be useful in older workbooks or layouts designed around floating controls. In Excel for Windows, enable the Developer tab through File > Options > Customize Ribbon and select Developer. Then choose Developer > Insert > Check Box under Form Controls and place the control on the sheet. To connect it to a cell, right-click the control, choose Format Control, open the Control tab, and set a cell link. That linked cell reports TRUE or FALSE as the box changes.

Form Controls can require more careful alignment and setup, particularly when rows are resized, copied, or sorted. ActiveX controls are another older Windows-specific control type and are not the same as Form Controls or in-cell checkboxes. Avoid choosing a legacy control just because an older tutorial uses it; first check whether the in-cell option meets the workbook’s needs. For collaborative files, confirm that people using different Excel platforms can work with the chosen control as expected.

Common problems and fixes

  • Checkbox is missing from Insert: Update Excel and confirm the app/version supports the in-cell checkbox feature. If you are following older instructions, they may instead refer to Developer controls.
  • Checkboxes show TRUE or FALSE rather than a box: Check whether you are looking at the cell value in a context where the checkbox display is unavailable, or whether the cells contain logical values without the checkbox feature applied. Re-select the intended cells and use Insert > Checkbox where supported.
  • Progress is wrong: Verify that the formula range covers the checkbox cells and that the task-count range includes only actual tasks. Blank task rows can affect a percentage if they are included in the denominator.
  • Task names no longer match checkboxes: Sort or move the entire table or complete rows, not just the checkbox column. The checked state belongs to its cell, so sorting one column alone can separate it from the task.
  • Copied boxes start checked: A copied checkbox cell may retain its current TRUE or FALSE state. Clear the boxes after copying, or insert checkboxes into the new blank range.

Frequently Asked Questions

Can I insert a checkbox in Excel without the Developer tab?
Yes. In current Microsoft 365 versions with the in-cell checkbox feature, select the target cells and choose Insert > Checkbox. The Developer tab is needed for the older Form Control method, not for this newer cell-based option.

How do I count checked boxes in Excel?
If the checkboxes are in B2:B10, use =COUNTIF(B2:B10,TRUE). It counts cells whose value is TRUE, so it returns the number of checked boxes in that range.

Can I use a checkbox to cross out a completed task?
Yes. Apply conditional formatting to the task-name cells using the corresponding checkbox state as the rule. The task remains in the worksheet, but its appearance changes when its box is checked.

Do Excel checkboxes contain text?
The modern in-cell checkbox represents a Boolean value: TRUE when checked and FALSE when unchecked. You can display a separate text status with an IF formula, but the checkbox itself is not a text label.

Can I use Excel checkboxes on Mac or in a browser?
Availability and ribbon placement can vary by Excel version and update channel. Look for the Checkbox command on the Insert tab in a current supported version. Legacy controls can behave differently across platforms, so verify a shared workbook in the apps its users will use.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.