Checklist in Excel: How to Create, Track, and Reuse One

How-to basics · Updated November 22, 2026

In Excel for Microsoft 365 on Windows, put your tasks in one column, select the cells beside them, and choose Insert > Checkbox to add clickable checkboxes. Add a heading and, if useful, a completion formula so you can see how many tasks are done.

What an Excel checklist can do

An Excel checklist is a worksheet that pairs items to complete with a way to mark their status. It can be as simple as a short packing list or as structured as a recurring inspection log with owners, due dates, and notes. Unlike a printed list, a spreadsheet can calculate totals, filter work by status, and be copied for the next round.

Excel for Microsoft 365 includes in-cell checkboxes: each checkbox is part of a cell rather than a separate object floating over the sheet. A checked box has the logical value TRUE, and an unchecked box has the value FALSE. That underlying value is useful because formulas and conditional formatting can respond to a click. The checkbox itself does not make a task complete automatically; you decide what each checked state means and keep the task information clear.

The feature may not appear in older Excel editions or every update channel. If Insert > Checkbox is missing, check that Excel is up to date and confirm which edition you are using. Older desktop versions can use Form Controls, described below, but those behave differently from in-cell checkboxes.

How to create a basic checklist

Start with a blank worksheet and give each column one job. For example, use column A for the task and column B for its completion checkbox. A short setup keeps the list readable and makes formulas easier to maintain:

  1. Enter a heading such as Task in A1 and Done in B1.
  2. Type one task per row, beginning in A2. Leave the matching cells in column B available for checkboxes.
  3. Select B2:B10, or select the status cells matching the number of tasks you have.
  4. Choose Insert > Checkbox. Excel adds a checkbox to each selected cell.
  5. Click a checkbox to mark the corresponding task complete. Click it again to clear it.

For example, a travel list might contain “Check in online,” “Pack charger,” and “Lock the front door.” Keep each task specific enough that another person could tell what completion means. If a task is actually a group of separate actions, split it into multiple rows; otherwise one check can hide unfinished work.

Use a descriptive sheet name, such as Packing List or Weekly Checks, and keep the header row visible if the list is long. On Windows, select the data and press Ctrl+T to format it as an Excel table; on Mac, the equivalent shortcut is Command+T. Tables provide built-in filter buttons and expand as rows are added. Confirm the range and whether it has headers in the dialog before selecting OK.

Organize tasks so the list stays usable

A checklist should show the information needed to act, not every detail about a project. A useful small list might have Task, Done, Owner, and Due date columns. For a household list, an owner or deadline may be unnecessary; for a team handoff, those fields can prevent ambiguity. Avoid putting multiple tasks in one cell, since that makes it difficult to mark or filter them independently.

Keep the checkbox beside its task. This matters when sorting or filtering: select and sort the entire list or table, not just the task column, so the status and other details move with the right row. If different tasks have different categories, add a Category column instead of separating them with blank rows. A consistent rectangular range is easier to filter, count, and reuse.

For recurring work, decide whether checked tasks should remain checked in the next cycle. You might duplicate a clean template with all boxes unchecked, or keep a dated history in separate rows or sheets. A dated log is more informative than repeatedly overwriting a single checklist when you need to know when a task was completed. Do not rely on a checkbox alone as proof of who completed an action or when; it records a current state, not a complete audit trail.

Count completed tasks and calculate progress

Because in-cell checkboxes store TRUE or FALSE, COUNTIF can count checked boxes. With task names in A2:A10 and checkboxes in B2:B10, enter =COUNTIF(B2:B10,TRUE) in a summary cell. If six of the nine boxes are checked, the result is 6. The formula counts checked cells in the status range; it does not count task names or determine whether the work was done correctly.

To show a completion percentage, use the same layout: task names in A2:A10 and checkboxes in B2:B10. Enter =IFERROR(COUNTIF(B2:B10,TRUE)/COUNTA(A2:A10),0) in a summary cell, then format that cell as a percentage using Home > Number. If six tasks are filled in and checked out of nine filled tasks, the result is 6 divided by 9, or about 66.7%. COUNTA excludes blank task cells from the denominator, and IFERROR displays zero rather than an error when there are no task names.

Place a label such as Completed or Progress beside the result so that someone opening the sheet understands it. If you add tasks below row 10, update the formula ranges or use a table-based layout that can be extended consistently. Always check that the task range and checkbox range cover the same rows; mismatched ranges can give a plausible-looking but misleading total.

Make completed work easy to scan

Conditional formatting can visually distinguish completed tasks without removing them from view. To shade the task text when its adjacent checkbox is checked, select A2:A10 and choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. With task names in A2:A10 and checkboxes in B2:B10, use =$B2=TRUE as the rule formula, choose a fill or font style, and confirm the rule. The dollar sign fixes the status column while the row reference adjusts for each task.

A light fill or muted font can help separate done items from open ones, but do not rely on color alone. Keep the checkbox visible, use readable contrast, and consider a text status or date if the sheet will be printed or read by people who may not distinguish colors easily. If the formatting appears on the wrong rows, review the rule’s Applies to range and make sure the formula references the first row of that range.

Share, print, and reuse the checklist

Before sharing a checklist, remove sample tasks or private notes and check that the formulas include the full list. If several people need to edit it, store the workbook somewhere that supports shared access in your organization, such as OneDrive or SharePoint, and check their permissions. The exact checkbox experience can vary by Excel edition and update status, so confirm that recipients can interact with the boxes in their version. If a recipient only needs to read the list, a PDF can preserve its appearance, but it will not function as an interactive checklist.

For printing, use File > Print to review the preview before printing. A wide list may need landscape orientation or a smaller print area; avoid shrinking it so much that task text becomes hard to read. If the checkbox feature is unavailable in the intended environment, consider using a plain Status column with values such as Not started and Done. Text statuses are less compact, but they are easy to read in exports and can be filtered.

To reuse a clean version, save a copy before entering cycle-specific information, or save a workbook as an Excel template using File > Save As and choose an Excel Template file type if offered. Retain headings, formatting, and formulas, but leave the task statuses in the state you want users to start from. Verify the copy has the intended blank or checked boxes before distributing it.

Common problems and practical alternatives

  • No Checkbox command: The in-cell feature is not available in every older Excel edition or build. Update Microsoft 365 where possible, or use a text status column or Form Controls instead.
  • The box changes but the total does not: Confirm the formula refers to the cells containing the checkboxes, not the task names, and that the selected range includes all rows.
  • Tasks and statuses become mismatched: Sort or filter the full table, not one column by itself. A checkbox is associated with its cell, so moving only the task text breaks the relationship.
  • A copied list carries old checks: Clear the status cells in the copy and verify the completion summary resets as expected.
  • Need compatibility with older workbooks: The Developer tab offers Form Controls on supported desktop editions. Enable the Developer tab through File > Options > Customize Ribbon on Windows, then use Developer > Insert and choose Check Box under Form Controls. These controls are separate objects placed over cells, not in-cell TRUE/FALSE checkboxes. They can require more setup and careful alignment, so a simple text status may be easier for a broadly shared file.

Form Controls can be linked to cells so formulas can read their states, but each control needs a cell link and may need to be positioned and copied carefully. They are not the same as choosing Insert > Checkbox. For a straightforward list, use in-cell checkboxes when available; for maximum compatibility, use text statuses such as Open and Done. Choose based on the Excel versions and sharing needs of the people who will use the file.

Frequently Asked Questions

Can Excel count checked boxes?
Yes. In-cell checkboxes return TRUE when checked and FALSE when unchecked. With checkboxes in B2:B10, =COUNTIF(B2:B10,TRUE) counts the checked cells.

Can I make a checklist in an older version of Excel?
Yes. Use a Status column with text such as Not started and Done, or add Form Control checkboxes from the Developer tab in a supported desktop edition. The modern Insert > Checkbox feature is not present in every older version.

Can I copy an Excel checklist for a new week?
Yes. Copy the worksheet or save a clean template, then clear the old checks and update any dates or tasks. Check that summary formulas still cover the full list after copying.

How do I show a line through completed tasks?
Select the task range and create a conditional-formatting rule based on the checkbox column. In the example above, the rule =$B2=TRUE can apply a muted font or other format to tasks in column A.

Will a checklist work in Excel for Mac or the web?
Feature availability and menu placement can differ by edition and update status. Check whether Insert > Checkbox is available in the version you use; if it is not, use a text status column or a compatible alternative and verify behavior before sharing.

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.