Checklist Examples in Excel: Templates and Formulas

Formulas & functions · Updated November 19, 2026

Useful checklist examples in Excel include task lists, inspections, inventory counts, event plans, and habit trackers. For a basic interactive list in Microsoft 365 on Windows, enter items in column A, select the matching cells in column B, and choose Insert > Checkbox; the boxes record TRUE or FALSE values that formulas can count.

What an Excel checklist can do

An Excel checklist is a worksheet organized around items that need to be completed, checked, or verified. It might be a simple list of tasks, or a small tracking system with an owner, due date, status, notes, and completion indicator. The right setup depends on whether the list is for one person, a team, a recurring process, or a printed inspection.

In current Microsoft 365 builds that support in-cell checkboxes, each checkbox is stored in its cell as a logical value: checked is TRUE and unchecked is FALSE. That makes the checkbox useful beyond its appearance: Excel formulas can count checked items, calculate completion, or drive conditional formatting. If Insert > Checkbox is not available in your Excel build, use a status dropdown or a legacy Form Control checkbox instead.

A checklist is not automatically a database or workflow system. Excel is a practical choice for modest lists that need sorting, filtering, calculations, or printing. For many people editing the same process, approval history, or controlled access, a dedicated task or form application may be more appropriate.

Build a basic task checklist

Start with a clear header row so the list is understandable when shared or printed. For a household or project task list, use columns such as Task, Done, Owner, Due date, and Notes. Keep one task per row; this makes it easier to filter unfinished work and add new items without redesigning the sheet.

  1. Type the headers in row 1, for example Task in A1, Done in B1, Owner in C1, and Due date in D1.
  2. Enter one task in each row of column A, such as “Book meeting room” and “Send agenda.”
  3. Select the intended cells in column B and choose Insert > Checkbox. In supported Microsoft 365 versions, the checkbox is placed in each selected cell.
  4. Fill in owners or dates as needed, then use Home > Format as Table to make the list easier to filter and extend.
  5. Save the workbook and test a few boxes and filters before sharing it.

Use specific task wording. “Prepare report” is easier to verify than “Work on report,” and splitting a large task into observable steps makes progress clearer. For dates, enter actual Excel dates rather than typed descriptions such as “next Friday,” so sorting and date-based formatting behave consistently.

Checklist examples for different needs

The same layout can support quite different routines. These examples show what to track and which extra columns make the checklist more useful:

  • Project or weekly task list: Task, Done, Owner, Due date, and Notes. Filter the Done column to show only items that remain open.
  • Cleaning or maintenance checklist: Area or equipment, Check, Date, Initials, and Issue found. A separate issue column helps distinguish “checked” from “everything passed.”
  • Inventory count: Item, Counted, Quantity, Location, and Reorder needed. A checkbox can indicate that a count was performed, but it should not replace the quantity itself.
  • Event preparation: Action, Done, Responsible person, Deadline, and Supplier or contact. Sort by deadline to see what needs attention first.
  • Quality or safety inspection: Checkpoint, Result, Inspector, Date, and Corrective action. For formal inspections, record the actual result and any required follow-up rather than relying on a single completion box.
  • Habit tracker: Habit in column A and one date per column, with checkboxes in the daily cells. A monthly grid is compact, but use dates as real date values and label the period clearly.

For a team checklist, include a responsible person and a due date where appropriate. A checkbox answers whether an item is marked complete; by itself it does not show who checked it, when it was checked, or what evidence supports completion. Add fields for those details when they matter.

Count completed items and calculate progress

Because in-cell checkboxes contain TRUE or FALSE, ordinary worksheet formulas can summarize them. For a small task list, suppose task names are in A2:A6 and their checkboxes are in B2:B6. With three boxes checked, enter =COUNTIF(B2:B6,TRUE) in a summary cell; it returns 3, the number of completed items.

With task names in A2:A6 and checkboxes in B2:B6, enter =COUNTIF(B2:B6,TRUE)/COUNTA(A2:A6) to calculate the completion fraction. If three of the five task names are present and checked, the result is 0.6; format the result as Percentage to display 60%. COUNTA counts non-empty task cells, so keep the task range limited to real checklist rows.

With task names in A2:A6 and checkboxes in B2:B6, enter =COUNTA(A2:A6)-COUNTIF(B2:B6,TRUE) to show the number still unchecked. If there are five tasks and three checked boxes, the result is 2. These counts assume every listed task has a checkbox; a blank checkbox cell is treated as not completed.

You can also show a word beside a checkbox. With a checkbox value in B2, enter =IF(B2,"Done","Open") in C2. If B2 is TRUE, the result is Done; if B2 is FALSE, it is Open. This is most useful when another report or export needs text labels, since the checkbox already communicates the state visually.

Formatting and filtering the list

Formatting should make exceptions easy to spot rather than decorate every cell. Freeze the header row with View > Freeze Panes > Freeze Top Row if a long list scrolls beyond the screen. Format due dates consistently, wrap long notes, and use filters to isolate overdue, unassigned, or unfinished work.

Conditional formatting can shade a task row when its checkbox is checked. For a list in A2:C6, with the checkbox values in B2:B6, select A2:C6 and go to Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Use =$B2=TRUE as the rule formula and choose a formatting style. The dollar sign fixes the status column while the row reference adjusts for each row. This rule highlights the row; it does not change or lock the checkbox.

For older Excel versions or workbooks where a visible in-cell checkbox is unavailable, use a dropdown status instead. Select the status cells, choose Data > Data Validation, set Allow to List, and provide options such as Open, In progress, and Done. Dropdown statuses are often better than a binary checkbox when work can be partially complete or needs a review state.

Choose between in-cell boxes and Form Controls

In-cell checkboxes are the simplest option for a new checklist in a supported Microsoft 365 version: the checkbox is part of the cell and its TRUE or FALSE value is available to formulas. This is convenient for copying, counting, filtering, and formatting the list as a table. If a coworker has an older Excel build, confirm that the checkbox appearance and behavior are supported before relying on it in a shared workbook.

Excel also has older checkbox controls. On Windows, enable the Developer tab through File > Options > Customize Ribbon if it is hidden, then choose Developer > Insert > Check Box under Form Controls. A Form Control checkbox sits on top of the sheet rather than being an in-cell value; right-click it, choose Format Control, and set a Cell link to store its state in a worksheet cell. The linked cell can then be referenced by formulas.

Form Controls can be useful for compatibility with older files, but many individual controls take more work to align and maintain. They may shift or overlap when rows are resized or sorted unless their properties are configured carefully. The control menus differ on Mac, so follow the options available in that Excel version; when sharing across platforms, test the workbook on the recipient’s version. Do not assume a drawn box or the character ☐ is a working checkbox: those are visual marks, not interactive values.

Common checklist problems

  • A formula counts zero: Check that the cells really contain checkbox values or linked TRUE/FALSE values. A typed word such as “Yes” is text and will not match a TRUE criterion.
  • Progress is wrong: Make sure every task row has a checkbox and that the denominator counts only actual tasks. Blank template rows can distort a percentage if the formula counts them.
  • Sorting scrambles the list: Keep the task and its related fields on the same row, then sort the complete table or selected data range. Sorting only the checkbox column separates statuses from their tasks.
  • The box is hard to click or print: Adjust column width and row height, and check Print Preview. In-cell boxes and floating Form Controls can print differently depending on layout and scaling.
  • Several people edit at once: Store the workbook in a supported shared location and confirm collaborators can edit it. Avoid using a checkbox alone as an audit trail if it is important to know who changed a value and when.

Another common misconception is that a checked box proves a task was completed correctly. It only records the selected state. Where accountability matters, add a date, initials, notes, or a review step, and protect important formulas or headings from accidental changes.

Printing, sharing, and maintaining a checklist

Before printing, use File > Print to inspect page breaks, scaling, margins, and whether all needed columns fit. A wide checklist may be easier to read in landscape orientation or across multiple pages than when reduced to fit on one page. Repeat the header row on additional printed pages when the list spans more than one sheet of paper.

For shared workbooks, label the meaning of each status and avoid ambiguous conventions. If unchecked means “not started,” say so; if it means “not yet verified,” use a separate status or note. Keep an uncompleted template sheet separate from a live working list if users need to reuse the checklist regularly, and make a backup before substantial structural changes.

Review recurring checklists occasionally. Remove obsolete tasks, clarify items that different people interpret differently, and set a clear date range for trackers. A carefully maintained list is more useful than adding extra columns that nobody updates.

Frequently Asked Questions

How do I insert a checkbox in Excel?
In a Microsoft 365 build with in-cell checkboxes, select the target cells and choose Insert > Checkbox. If that command is missing, update or check your Excel version, or use Developer > Insert > Check Box under Form Controls on Windows.

Can Excel count checked boxes?
Yes. In-cell checkboxes store TRUE when checked and FALSE when clear, so COUNTIF can count the TRUE values. For Form Controls, first link each box to a cell, then count the linked values.

How do I show checklist progress as a percentage?
Divide the number of checked boxes by the number of tasks, then format the result cell as a percentage. Ensure the task count excludes blank template rows, or the displayed progress will be too low.

Can I sort a checklist without separating the boxes from tasks?
Yes. Put each task and its related information on one row, preferably in a table, and sort the whole table using its header filter. Avoid sorting a single status column by itself.

Can I make a checklist in older Excel?
Yes. Use a Data Validation dropdown with status choices, or use legacy Form Control checkboxes and link each control to a cell. Dropdowns are usually simpler when the workbook must work in older versions or needs more than two states.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.