Checklist in Excel: Create, Track, and Test a List

How-to basics · Updated November 22, 2026

Yes. In Microsoft Excel for Microsoft 365, you can create a checklist by putting tasks in one column and adding clickable checkboxes in another; checked boxes can also feed formulas that count completed tasks and calculate progress. To test it, check and uncheck sample items and confirm that the displayed totals and percentage update as expected.

What a checklist in Excel can do

An Excel checklist is a worksheet that pairs tasks or inspection points with a way to mark their status. It can be as simple as a packing list or as structured as a recurring quality review. The value is not just seeing which boxes are checked: Excel can summarize completion, highlight unfinished work, sort or filter items, and provide a record that can be reviewed later.

A checklist is not automatically a secure audit trail. A checked box usually records only the current state, not who checked it or when. If responsibility, dates, evidence, or approvals matter, add separate columns for those details, and consider whether a shared workbook or a dedicated tracking system is more appropriate.

Plan the columns before adding checkboxes

Start with a clear layout so people know what each entry means. For a basic list, use column A for the task and column B for its checkbox. For a team process, you might also use columns for an owner, due date, notes, and evidence. Put a heading in the first row and begin the list below it.

For example, a ten-step event-preparation checklist could have headers Task and Done in A1:B1, followed by ten task names in A2:A11. Keep one task per row. If a task has several independent requirements, split it into separate rows; a single checked box should mean one specific thing has been completed.

  • Use short, action-oriented task names, such as “Confirm room booking,” rather than vague labels such as “Room.”
  • Keep instructions and supporting detail in a Notes column instead of making task names difficult to scan.
  • Decide what counts as complete before distributing the list. For example, does “Send report” mean sent, or sent and acknowledged?

Add clickable checkboxes in Microsoft 365

In current Excel for Microsoft 365, in-cell checkboxes are the simplest option for a normal checklist. Select the cells where the boxes should appear, then choose Insert > Checkbox. For the example above, select B2:B11 first. Each cell then behaves as a checkbox: clicking it changes its value between checked and unchecked.

  1. Enter the task names in A2:A11 and a heading such as Done in B1.
  2. Select B2:B11, or the corresponding status cells for your own list.
  3. Choose Insert > Checkbox.
  4. Click a few boxes to mark tasks complete. Use the same cells for the full checklist so each status stays aligned with its task.

These checkboxes store TRUE when checked and FALSE when unchecked. That makes them useful in formulas and conditional formatting without needing a separate linked cell. The command is available in current Microsoft 365 versions, but feature availability can depend on the Excel platform and update channel. If you do not see Insert > Checkbox, update Excel if possible or use the classic control method described below. On Excel for the web and Mac, menu placement or availability may vary by release; look for Checkbox on the Insert tab.

Count completed items and calculate progress

To summarize a checklist, use a formula that counts TRUE values in the checkbox cells. With tasks in A2:A11 and their in-cell checkboxes in B2:B11, enter this in a summary cell:

=COUNTIF(B2:B11,TRUE)

If six of the ten boxes are checked, the result is 6. The formula counts completed boxes, not task names, so the ranges should cover the same rows. If the checklist grows, extend the range or convert the task area to an Excel table and adjust the formula to suit the table structure.

To show completion as a percentage, with task names in A2:A11 and checkboxes in B2:B11, enter:

=IFERROR(COUNTIF(B2:B11,TRUE)/COUNTA(A2:A11),0)

With six checked boxes and ten nonblank task names, the result is 0.6; apply Percentage format to display 60%. COUNTA counts the filled task cells, so this denominator adjusts if some rows are left empty. IFERROR returns zero rather than an error when the task list has no entries. It does not validate whether each task has a corresponding checkbox, so keep the two columns aligned.

A progress percentage can be misleading if all tasks are not equally important. For instance, completing nine small preparation tasks out of ten does not necessarily mean a project is 90% ready if the remaining task is a critical approval. Use a separate priority or sign-off field when the order or importance of work matters.

Make the list easier to scan

Formatting helps readers use a checklist correctly. Make the headers distinct, widen the task column, and use Wrap Text if instructions need more than one line. Freeze the header row with View > Freeze Panes > Freeze Top Row if the list is long. Keep color as a visual aid rather than the only indicator of status: a checkbox and clear task wording should still communicate completion.

You can use conditional formatting to shade completed tasks. Select A2:A11, then choose Home > Conditional Formatting > New Rule and create a rule that uses a formula. With the first task on row 2 and its checkbox in B2, use the formula =$B2=TRUE and choose a subtle fill. The dollar sign fixes the status column while allowing the row number to adjust. Check the rule range to ensure it covers the task rows, and avoid a strong style that makes text hard to read.

For a simple visual indicator, another option is to put the completion count and percentage in clearly labeled cells above or beside the list. Do not rely only on a progress bar or color: someone printing the sheet or using a screen reader may need the written count and status information too.

Test the checklist before relying on it

Testing means checking both the interaction and any summaries, not merely confirming that boxes appear. Make a copy of the worksheet or use a small sample before entering real work. Try the following checks:

  • Click an unchecked box and confirm it becomes checked; click it again and confirm it clears.
  • Check one box and verify the completed count changes from 0 to 1 and the percentage changes by the expected amount.
  • Check all ten boxes and confirm the count is 10 and the percentage is 100%.
  • Clear one box and confirm the summary falls back to 9 and 90% for a ten-task list.
  • Leave a task-name row blank and confirm the percentage denominator behaves as intended.
  • Save, close, and reopen a test copy to confirm that the status values remain as expected.

If several people will use the file, check it in the same application and platform they will use. Differences in available features, editing permissions, or workbook compatibility can affect how a control appears. A small test with the actual recipients is more reliable than assuming every Excel version has identical behavior.

In-cell checkboxes versus classic controls

In-cell checkboxes are usually the better choice for a straightforward list because their TRUE/FALSE values are stored directly in cells. They work naturally with formulas, and filling a range with checkboxes is quick. They are also easier to copy and manage as worksheet data than individual floating objects.

Classic Form Control checkboxes are an alternative when a workbook uses older checkbox controls or when the in-cell option is unavailable. In Excel for Windows, enable the Developer tab if needed through File > Options > Customize Ribbon, then choose Developer > Insert and select the checkbox under Form Controls. A Form Control can be linked to a worksheet cell through its Format Control settings; the linked cell returns TRUE or FALSE. Such controls are objects placed over the grid, so they may need careful alignment when rows are resized or sorted. ActiveX controls are a different type of control and should not be confused with Form Controls.

For checklists that need detailed accountability, an ordinary status column with values such as Not started, In progress, and Complete may be clearer than a checkbox. Use Data > Data Validation to create a drop-down list of allowed statuses. That approach can represent partial progress, while a checkbox represents a simple yes-or-no state.

Common problems and practical fixes

If Insert > Checkbox is missing, first confirm that you are using a version of Excel that supports in-cell checkboxes and that Office is up to date. The command may not appear in older perpetual-license versions or some managed installations. Use a classic Form Control or a validated status drop-down if upgrading is not an option.

If a count stays at zero, check that the formula refers to the checkbox cells and not the task names. For in-cell checkboxes, verify that checked cells contain TRUE. If using a Form Control, verify that each control is linked to the intended cell. Also check for mismatched ranges: counting B2:B11 while the actual boxes are in C2:C11 will not count the selected items.

If checkboxes appear to move away from their tasks, especially with classic controls, remember that those controls float above the grid. Review their placement after changing row heights, sorting, or filtering. For a list that will frequently change, in-cell checkboxes or a status column are generally less fragile.

Finally, avoid making a checkbox the only place where important information exists. A checkbox does not explain why an item is incomplete, who verified it, or what evidence supports completion. Add fields for those details when they are needed, and protect formula cells if accidental edits to summaries would cause confusion.

Frequently Asked Questions

Can Excel count checked boxes automatically?
Yes. In-cell checkboxes return TRUE when checked, so COUNTIF can count them. For example, with boxes in B2:B11, =COUNTIF(B2:B11,TRUE) returns the number checked.

Can I make a checklist without checkboxes?
Yes. Use a status column with a Data Validation drop-down such as Not started, In progress, and Complete. This can be easier to maintain when tasks have more than two possible states.

Why can’t I find Checkbox on the Insert tab?
The in-cell checkbox feature is not available in every Excel version or update channel. Check for Office updates; if the command remains unavailable, use a Form Control checkbox or a drop-down status list.

Can I use a checkbox checklist in Excel for the web or Mac?
Current releases may support in-cell checkboxes, but availability and interface details can vary by platform and update. Look on the Insert tab and test the workbook in the version that will be used to edit it.

Can a checkbox record who completed a task?
Not by itself. A checkbox records a status, not the identity or time of the person who changed it. Add separate name and date fields if those details are required, and decide how edits will be reviewed.

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.