Checklist Format in Excel: Create and Track Tasks

How-to basics · Updated November 22, 2026

To make a checklist in Excel for Microsoft 365 on Windows, enter tasks in one column, select the cells beside them, and choose Insert > Checkbox. Each checkbox records a checked or unchecked value, so you can track progress, count completed items, and apply formatting to finished tasks.

What an Excel checklist can do

An Excel checklist is a worksheet that pairs items to complete with a clear way to mark their status. It can be as simple as a set of unchecked boxes beside a short list, or it can be a reusable tracker with owners, due dates, notes, and a completion summary. The best layout depends on whether you are tracking a one-time job, a recurring routine, or work shared by several people.

Excel’s current in-cell checkboxes are useful because a checked box evaluates as TRUE and an unchecked box evaluates as FALSE. That value can feed formulas and conditional formatting; it is not merely a symbol pasted into a cell. This distinction is helpful when you want to calculate how many tasks are done or visually mark completed rows.

  • Personal list: errands, packing items, or a weekly routine.
  • Work tracker: project actions, review steps, or equipment inspections.
  • Reusable template: a process that needs the same steps each time.

Set up a clear checklist layout

Start with a small table rather than scattering task names across the sheet. Put a heading such as “Task” in A1 and “Done” in B1, then list each action below the task heading. If the list needs more context, add columns for an owner, due date, or notes. Keep each task to one row so that sorting, filtering, and formatting work predictably.

For example, a project handoff checklist might have columns for Task, Done, Owner, Due date, and Notes. A household packing list may need only Item and Packed. Use concise action wording—“Confirm venue booking” is easier to verify than “Venue”—and separate genuinely different actions into separate rows. Avoid merging cells inside the checklist table: merged layouts can make sorting and filtering awkward.

  1. Type the column headings in the first row.
  2. Enter one task per row underneath the relevant heading.
  3. Leave the column beside each task for its checkbox.
  4. Optionally select the headings and task data, then use Home > Format as Table to create a structured, filterable table.

Formatting as a table is optional. For a compact personal list, ordinary worksheet cells are often enough. If you use a table, keep the checkbox column within the task rows and check that new rows added later receive the formatting and checkbox setup you expect.

Insert checkboxes in Microsoft 365

In current Microsoft 365 editions of Excel for Windows, select the blank cells intended for checkboxes and choose Insert > Checkbox. Selecting a range first can add a checkbox to each selected cell, which is faster than inserting them one at a time. Click a box to switch it between checked and unchecked. The cell itself holds TRUE when checked and FALSE when unchecked, allowing ordinary Excel formulas to use the result.

If the Checkbox command is not available, check that Excel is up to date and that you are using a version with the in-cell checkbox feature. Feature availability can vary by update channel and platform. Excel for the web also has in-cell checkbox support in current versions, though the ribbon and surrounding interface may differ. On Mac, availability and the exact ribbon presentation can depend on the installed Excel release; look on the Insert tab for Checkbox rather than assuming the Windows menu is identical.

Older versions, or installations without the newer feature, can use legacy Form Controls. First enable the Developer tab through File > Options > Customize Ribbon, then select Developer > Insert > Form Controls > Check Box. Draw the control beside a task and edit or remove its default caption as needed. To connect a Form Control to a cell, right-click it, choose Format Control, open the Control tab, and set a cell link. The linked cell then reports the control’s state. These controls are separate objects over the worksheet, unlike the newer checkboxes stored directly in cells.

Track progress with formulas

Checkbox values can power a simple progress report. With checkboxes in B2:B6, where B2:B6 are the five task status cells, enter this formula in another cell to count completed tasks:

=COUNTIF(B2:B6,TRUE)

If three of those five boxes are checked, the result is 3. To show a status beside the first task, with its checkbox in B2, enter this in C2 and fill it down for the other rows:

=IF(B2,"Done","Pending")

When B2 is checked, the result is Done; when it is unchecked, the result is Pending. You can use the count to calculate a completion percentage. With task names in A2:A6 and their checkboxes in B2:B6, enter this formula in a summary cell:

=IFERROR(COUNTIF(B2:B6,TRUE)/COUNTA(A2:A6),0)

If all five task names are present and three boxes are checked, the result is 0.6, or 60% when the cell is formatted as a percentage. IFERROR prevents a divide-by-zero error if there are no task names. COUNTA counts nonempty task cells, so keep the task list free of stray entries below the actual items.

These examples assume the newer in-cell checkboxes, which return TRUE or FALSE. If you use legacy Form Controls, the formulas should refer to the cells linked to those controls, not to the drawn checkbox objects. Once you have a count or percentage, you can label it “Completed” or “Progress” so the meaning is clear to anyone opening the workbook.

Make completed tasks easier to see

Conditional formatting can change the appearance of a task row when its checkbox is checked. For a checklist with task names in A2:A6 and checkboxes in B2:B6, select A2:A6, then choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Use this rule formula:

=$B2=TRUE

Choose a format such as a gray font or strikethrough, then confirm the rule. The dollar sign fixes the checkbox column while the row number adjusts for each task. To format the full task row instead, select the row range, such as A2:E6, before creating the rule, and keep the formula tied to column B. This gives a quick visual signal without deleting completed tasks or hiding useful history.

Use color with care. A muted style for completed work and a clear heading are usually easier to read than several competing colors. Do not rely on color alone to communicate status, especially in a shared or printed checklist; the checkbox and a text label can provide an additional cue.

Choose between in-cell boxes and Form Controls

For a new Microsoft 365 checklist, in-cell checkboxes are usually the straightforward choice: they live in cells, copy and fill like cell content, and return TRUE or FALSE directly. That makes them convenient for formulas, filters, and conditional formatting. They also keep a basic list aligned as row heights or column widths change.

Form Control checkboxes are older worksheet objects. They can be useful when maintaining a workbook built around controls or when the user needs a clickable object placed over a particular area. However, each control can require its own positioning and a linked cell for formula work. Moving, copying, or sorting rows that contain controls may need extra attention. Do not mix the two styles without a reason: users may not know whether a visible box is a cell value or a floating object.

If a workbook will be opened by colleagues on different devices or Excel versions, test the checklist in the actual environments they use. A plain text status column such as “Not started,” “In progress,” and “Done” may be a more compatible alternative when checkbox support or object behavior is uncertain.

Common problems and practical fixes

  • The checkbox option is missing: Confirm the app and update channel support in-cell checkboxes, and install available Microsoft 365 updates. If it remains unavailable, consider a status dropdown or legacy Form Controls.
  • The formula shows zero: Check that the formula range matches the checkbox cells and that the cells contain checkbox values rather than typed symbols. For Form Controls, verify that each control has the correct linked cell.
  • A copied checkbox does not behave as expected: Check the selected range and any copied formulas or linked-cell references. For older controls, confirm that copied objects link to the intended cells.
  • Sorting separates tasks from their status: Select and sort the whole data range or table, not just the task-name column. Keeping every task and its status on the same row is essential.
  • The printed checklist has no usable boxes: A printed page cannot be clicked. Use the workbook’s print preview and margins, and consider printing empty square symbols or a separate paper-friendly version if people will mark it by hand.

Another common misconception is that a checkbox automatically marks a task as complete when a due date passes or when another cell changes. A checkbox records the user’s selection; it does not understand the task or verify that the work is finished. If completion needs evidence, include a notes or approval column and define who is responsible for checking it.

Sharing, printing, and maintaining the checklist

Before sharing a checklist, make the purpose and ownership clear. A heading can identify the project or time period, while columns for owner and due date help teams distinguish responsibility from completion. If several people will edit the file, store it in a shared location that supports co-authoring and tell collaborators which cells they should change. Avoid protecting the sheet in a way that prevents users from clicking the intended checkboxes.

For a paper copy, use File > Print to inspect the preview before printing. Set a useful print area if the worksheet contains unrelated material, and check scaling so task names remain legible. A screen checklist and a paper checklist behave differently: printed boxes are marks on a page, not interactive Excel controls. If handwritten updates must later be entered into the workbook, leave enough space for notes or provide a dedicated comments column.

For recurring checklists, decide whether completed items should be reset, archived, or retained with a date. Clearing all boxes may be fine for a weekly routine, but it also removes the record of what was done. For a process that needs an audit trail, duplicate a dated sheet or record completion dates and owners instead of simply resetting the same list. Keep a clean master template separate from completed copies so the original steps are not accidentally changed.

Alternatives when checkboxes are not the right fit

A dropdown status list can be more informative than a binary box. Select the status cells and choose Data > Data Validation, then set the validation criteria to a list and provide options such as Not started, In progress, and Done. The exact dialog may vary slightly by Excel release. This approach needs more clicks but captures intermediate states that a single checkbox cannot express.

A simple text column is another dependable option for files that move between spreadsheet apps or older Excel installations. Users can type a short status or use a consistent symbol, although typed entries are easier to make inconsistent. For structured workflows with assignments, deadlines, notifications, or approval history, a project-management or task-tracking tool may fit better than a worksheet. Excel is most effective when the list and its reporting needs remain simple enough for people to maintain reliably.

Frequently Asked Questions

Can I count checked boxes in Excel?
Yes. With in-cell checkboxes in B2:B20, use =COUNTIF(B2:B20,TRUE) to count checked items. The range in the formula must match the cells containing the checkboxes.

Can Excel show a percentage of completed tasks?
Yes. Count checked boxes and divide by the number of task names. For example, with task names in A2:A20 and checkboxes in B2:B20, use =IFERROR(COUNTIF(B2:B20,TRUE)/COUNTA(A2:A20),0) and format the result as a percentage.

How do I add a checkbox to every task row?
Enter the task list, select the corresponding blank cells in the status column, and choose Insert > Checkbox in a supported Microsoft 365 version. If the command is missing, use a supported alternative such as a status dropdown or legacy Form Controls.

Can I use a checkbox in Excel for the web?
Current Excel for the web supports in-cell checkboxes, though the interface may differ from Excel for Windows. If a workbook uses older Form Control objects, check how those controls behave in the browser before relying on them.

Can I print an Excel checklist and tick the boxes on paper?
You can print the worksheet, but the printed controls are not interactive. Check the print preview and leave enough space to mark each item by hand; record paper changes in the workbook separately if you need an updated digital copy.

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.