A simple checklist template in Excel needs a task column, a status column, and optional fields for an owner, due date, and notes. Create those headers in row 1, add one task per row, and use a status dropdown such as Not started, In progress, and Done to make the list easy to update and review.
Start with a practical checklist layout
For a general-purpose checklist, put these headings in row 1: Task, Owner, Due date, Status, and Notes. Each row below represents one action. This arrangement works for a home project, a work handoff, an event plan, or a recurring inspection, while leaving room to see who is responsible and what still needs attention.
- Task: Write an action that can be completed and checked off, such as “Confirm room booking.”
- Owner: Name the person responsible. Leave this column out if the checklist is only for individual use.
- Due date: Enter a date only when timing matters. Avoid adding deadlines to tasks that do not need them.
- Status: Use consistent choices rather than several versions of “finished.”
- Notes: Record brief context, a link, or a dependency; keep detailed project discussion elsewhere.
Keep the first version small. Extra columns can make a checklist harder to scan, so add fields only when they help someone decide what to do next. For a packing list, for example, Task and Status may be enough. A team handoff may need Owner and Due date as well.
Build the template in Excel
In Excel for Microsoft 365 on Windows, open a blank workbook, type the column headings in row 1, and enter a few example tasks beneath them. Select the range and choose Home > Format as Table. Pick a style, confirm that the table has headers, and select OK. A table provides filter buttons and extends its formatting when you add rows, which is useful as a checklist grows.
To make the file reusable, replace example tasks with neutral prompts or leave several blank rows. Save it as an Excel workbook using File > Save As. If you intend to reuse the same blank layout, you can also save a separate copy before filling in a real checklist. Excel for Mac has the same Format as Table command on the Home tab; ribbon placement can vary slightly with window size and version.
For a very small list, a formal table is optional. You can still type headings and tasks into cells, but tables make sorting and filtering more reliable. When you later add a task, enter it in the first row immediately below the table so Excel can extend the table automatically.
Add a status dropdown
A dropdown reduces inconsistent entries such as “complete,” “Completed,” and “done,” which otherwise make counts and filters less dependable. Select the cells under Status, for example D2:D21, then choose Data > Data Validation. Set Allow to List and enter Not started,In progress,Done in Source, then select OK. The dropdown arrow lets a user choose one of the three values. In Excel for Mac, Data Validation is also on the Data tab.
Adjust the source choices to match the work. A review process might use Draft, In review, and Approved; a maintenance check could use Pass, Needs attention, and Not applicable. Choose short labels that are distinct and easy to interpret. If you change the wording later, update the validation list too, or old values may remain in existing cells.
Do not use a status dropdown to represent several different facts. “Done” describes completion, while “Blocked” describes a problem; if both matter, consider a separate Blocker or Notes field. A checklist is most useful when its labels mean the same thing to every person updating it.
Show an overall completion percentage
A completion figure can summarize progress, but it depends on a clear denominator. With task names in A2:A21 and status values in D2:D21, enter this formula in a cell outside the table, such as D23:
=IFERROR(COUNTIF(D2:D21,"Done")/COUNTA(A2:A21),0)
Format the result cell as a percentage using Home > Number > Percent Style. If four task names are present and two corresponding status cells contain Done, the formula returns 50%: COUNTIF counts two completed tasks and COUNTA counts four nonblank task names. IFERROR displays zero if there are no task names yet, instead of showing a division error.
This calculation treats every named task equally and counts tasks that are not started or in progress as incomplete. If the list includes headings, explanatory notes, or rows with no task name, keep those outside the counted range. For a checklist with a different number of rows, adjust both ranges so they cover the same task rows. You can also omit the percentage entirely if a filtered list of unfinished tasks is clearer.
Make the checklist easy to scan
Use readable formatting rather than decoration that competes with the task names. Freeze the header row with View > Freeze Panes > Freeze Top Row if the list is long. Turn on text wrapping for Notes, widen the Task column, and use a consistent date format. On Windows, Ctrl+T opens the Create Table dialog for a selected range; on Mac, the corresponding shortcut is Command+T. Using Home > Format as Table is an alternative on either platform.
Conditional formatting can make a status or approaching deadline easier to spot. Select the status cells and use Home > Conditional Formatting to apply a rule for cells containing Done, or choose a built-in highlight rule. Use color as a visual cue, not the only way to communicate meaning: keep the status text visible so the sheet remains understandable when printed in black and white or viewed by someone who cannot distinguish the chosen colors.
For due dates, decide what “late” means before adding a warning rule. A past date may not indicate a problem if the task is already Done or the deadline has changed. If you use conditional formatting, test it on a few sample rows and confirm it behaves correctly for blank dates and completed tasks. A simpler option is to sort or filter by Due date during a review.
Use filters and sort without losing track
Excel tables include filter controls in the header row. Filter Status to show only Not started or In progress when planning the next work session, or filter Owner to review one person’s tasks. Sorting by due date can bring earlier deadlines to the top. Clear the filter afterward if someone else expects to see the full checklist; a hidden row can look like a missing task to an unfamiliar user.
Sort the entire table, not a single column by itself. Sorting only the dates or only the task names can separate values that belong on the same row. If Excel prompts you to expand the selection, choose that option so the task, owner, date, and status stay together. Before sharing a filtered workbook, consider whether the recipient should see the filtered view or the whole list.
Choose the right level of detail
Write checklist items at a consistent level. “Prepare launch” is broad and difficult to mark complete, while “Check the launch email links” is a specific action. If a broad task contains several independent actions, split it into separate rows when each action may have a different owner or completion time. If the steps are inseparable, one parent task with concise substeps in Notes may be easier to manage.
Use dates and owners selectively. Adding an owner to every personal packing task offers little value, while leaving ownership blank in a shared operations checklist can create confusion. The same is true of notes: include information someone needs to act, but avoid turning the workbook into a long narrative that is difficult to maintain.
For recurring work, include a date or cycle identifier so users can tell which run the checklist describes. For example, a monthly closing checklist could include a “Period” field or a separate worksheet for each period. Reusing a completed checklist without resetting its statuses is a common source of mistakes, so make a fresh copy for each cycle or clearly distinguish archived runs.
Common problems and simple fixes
- The completion percentage looks wrong: Check that the status spelling exactly matches Done and that the task and status ranges cover the same rows. Extra task names in the denominator lower the percentage, even if they are not real checklist items.
- The dropdown is missing: Confirm that Data Validation was applied to the intended cells. Pasting content into cells can replace validation, so test a dropdown after copying rows or importing data.
- New rows do not match the format: Add rows directly beneath the table, or extend the table from its edge. A row pasted far below may remain outside the table and its filters.
- Dates sort strangely: Some entries may be text rather than actual Excel dates. Enter dates consistently and check the cell format; changing a display format alone does not always convert text into a date value.
- People overwrite formulas: Put summary calculations in a clearly labeled area outside the task-entry columns. Explain which cells are intended for editing, and consider protecting formula cells if the workbook needs stricter controls.
A checklist is a lightweight tracking tool, not a guaranteed record of approval or proof that work was performed. For regulated, safety-critical, or audited procedures, use the organization’s approved process and recordkeeping requirements rather than assuming a basic spreadsheet is sufficient.
When to use a checkbox or another tool
A status dropdown is often the best starting point because it can express more than a binary choice and works across many Excel setups. If your Microsoft 365 version shows Insert > Checkbox, a checkbox can suit a simple complete/not-complete list. In current builds that support the feature, a checked box is stored as TRUE and an unchecked box as FALSE. Availability can depend on the Excel build, so use the dropdown if the command is not present or if recipients use older software.
For a checklist with only a few tasks, a printed page or a notes app may be faster than maintaining a workbook. For a shared project with assignments, discussions, notifications, and dependencies, a dedicated task-management service may fit better. Excel is a good choice when the list benefits from a familiar grid, custom columns, filtering, and a straightforward summary, but it does not automatically provide a complete workflow system.
Frequently Asked Questions
Does Excel have a checklist template?
Excel may offer templates through its New workbook screen, and available templates can vary by version and account. You can also create the simple layout described here in a blank workbook. Building it yourself makes it easier to control the task fields and status choices.
How do I make a checklist in Excel with checkboxes?
If your Microsoft 365 build includes the feature, select the target cells and choose Insert > Checkbox. Click a box to change its state. If Insert > Checkbox is unavailable, use Data > Data Validation to create a status dropdown instead; that option also supports states such as In progress.
How do I count completed tasks?
With status entries in D2:D21 and the word Done used consistently, COUNTIF can count completed rows: =COUNTIF(D2:D21,"Done"). The result is the number of cells marked Done. To calculate a percentage, divide that count by the number of task names, as in the formula above.
Can I use the checklist in Excel for the web or on Mac?
Basic cells, tables, dropdown validation, and formulas are available across current Excel editions, although ribbon placement and some newer features can differ. The steps here name the Microsoft 365 Windows paths; on Mac, the same ribbon tabs generally contain the relevant commands. Check the specific build if a newer checkbox command is missing.
How do I reuse a checklist without carrying over old progress?
Save a clean blank copy before entering statuses, then duplicate that copy for each new project or cycle. Alternatively, clear only the prior task entries and status values after archiving the completed version. Keep any formulas and validation rules in place, and verify the new copy before relying on it.
Related
- PowerShell Refresh Excel Power Query: How It Works
- Power Query: Get Excel Files From a Folder in Excel
- Power Query Excel Number Format: What You Can Control
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Sort Google Sheets and Keep the Top RowTo sort data in Google Sheets without moving the top row, select the table, choose Data > Sort…
- Can You Shade Half a Cell in Excel? Options ExplainedExcel does not have a built-in cell format that fills exactly half of a cell with one color…
- Excel Data Validation List: Create a Yes/No DropdownYes—Excel can use Data Validation to create a Yes/No dropdown in a cell. Select the cells, open Data…
- Excel Merge Cells Shortcut: Keys and Other OptionsIn Excel for Microsoft 365 on Windows, select the cells and press Alt, H, M, C—one key at…
- Excel Data Validation Lists: Setup, Tips, and FixesYes. Excel has data validation lists, which add a drop-down menu to a cell so people can choose…
- How to Hide Columns in Excel on iPad Without Deleting DataTo hide a column in Excel on iPad, tap its letter at the top of the worksheet to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.