Excel Sheet Checklist Template: How to Build One

How-to basics · Updated November 22, 2026

An Excel sheet checklist template is a pre-structured workbook that uses checkboxes, conditional formatting, and formulas to track tasks, items, or approvals. You can build one in under five minutes using the Developer tab and a few built-in functions, or download a free template from Microsoft’s official template gallery.

Why Use a Checklist Template in Excel

Checklists reduce errors by making each step visible and checkable. In Excel, a checklist goes beyond a static list: you can count completed items, highlight overdue tasks, and share the file with a team. Unlike paper or plain text lists, an Excel checklist can automatically show progress (e.g., “7 of 12 done”) and apply color rules so you instantly see what needs attention.

Common uses include:

  • Weekly cleaning or maintenance tasks
  • Employee onboarding steps
  • Packing lists for travel or moving
  • Quality inspection checks
  • Project milestone tracking

How to Build a Checklist Template from Scratch

Here is the fastest way to create a working checklist in Excel for Microsoft 365 (Windows). The steps are nearly identical on Mac, but you open the Developer tab via Excel > Preferences > Ribbon & Toolbar.

  1. Show the Developer tab (if not visible): Right-click any ribbon area > Customize the Ribbon > check “Developer” > OK.
  2. Add checkboxes: On the Developer tab, click Insert (in the Controls group), choose the Check Box (Form Control) icon, then click on a cell (e.g., B2). Drag to size if needed.
  3. Link each checkbox to a cell: Right-click the checkbox > Format Control > Control tab > set “Cell link” to a helper column (e.g., C2). This makes the cell return TRUE when checked, FALSE when unchecked.
  4. Copy the checkbox down: Select the cell with the checkbox, press Ctrl+D (Windows) or Cmd+D (Mac) to fill down for each task row. Each copy will link to its own row’s helper cell if you set the link relative.
  5. Add a progress formula: In a summary cell, use =COUNTIF(C2:C10,TRUE)/COUNTA(C2:C10) (assuming tasks in A2:A10 and helper cells in C2:C10). Format the result as a percentage.

That gives you a functional checklist. To make it look like a polished template, add a title, borders, and a data validation drop-down for priority or status columns.

Using Conditional Formatting to Automate Visual Cues

Conditional formatting makes your checklist react to the checkbox state. For example, you can strike through completed tasks:

  1. Select the range with task names (e.g., A2:A10).
  2. Go to Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format.
  3. Enter the formula =$C2=TRUE (assuming C is the helper column).
  4. Click Format > Font, check Strikethrough, and choose a gray font color.

You can also highlight overdue rows by comparing a due date column to =TODAY(). For instance, if due dates are in D2:D10, use the rule =AND($D2<TODAY(),$C2=FALSE) to fill the row red.

Free Templates vs. Building Your Own

Microsoft offers several free checklist templates directly in Excel. To access them, go to File > New and search “checklist” or “to-do list.” These include a simple “To-do list” with priority levels and a “Multiple project tracking” template. They are ready to use and often include pre-set conditional formatting.

Building your own gives you full control over columns, formulas, and layout. If you need a specific workflow (e.g., a pre-trip inspection with 50 items and a sign-off section), a custom template is better. For quick personal use, a downloaded template saves time.

Common Problems and How to Fix Them

Checkboxes not linking correctly when copied: If you copy a checkbox and the cell link stays the same, edit each one manually (right-click > Format Control > Cell link). To avoid this, create the first checkbox, set its link, then copy the cell; Excel usually adjusts the link relative to the row.

Checkbox size or alignment issues: Right-click the checkbox, select Format Control, and adjust the size or move it with the arrow keys while holding Alt to snap to the grid.

Counting checked items returns 0: This usually happens because the helper cells are not linked. Verify each checkbox’s cell link points to the correct row.

Checklist works on your PC but not on a colleague’s phone: Form controls are not supported in Excel for the web or mobile apps. If you need cross-device compatibility, use a simple drop-down list (Data > Data Validation > List with “Done,Not Done”) instead of checkboxes.

Checklist vs. To-Do List vs. Task Tracker

These terms are often used interchangeably, but in Excel they differ in scope:

  • Checklist: A simple list of items to verify, usually with a checkbox and no dates or owners.
  • To-do list: Adds due dates, priority, and sometimes a status column; often used for personal tasks.
  • Task tracker: A full project management tool with assignees, dependencies, and progress percentages.

For a checklist, you only need a checkbox and a description. For a to-do list, add a due date and a priority column. For a task tracker, add columns for owner, start date, and % complete, and use a formula like =COUNTIF(F2:F10,"Done")/COUNTA(F2:F10) to show overall progress.

Costs and Alternatives

Excel itself is part of Microsoft 365 (from about $6.99 per month for personal use), but the checklist templates are free. Free alternatives include Google Sheets (which has native checkboxes via Insert > Checkbox), and online tools like Trello or Asana for team collaboration.

If you need a checklist that multiple people can edit simultaneously, Google Sheets or a web-based app may be better. Excel files can be shared via OneDrive, but real-time co-authoring requires a Microsoft 365 subscription.

Frequently Asked Questions

How do I add a checkbox in Excel without the Developer tab?

You can use a cell with data validation: select the cell, go to Data > Data Validation > Allow: List, and enter TRUE,FALSE in the Source box. This creates a drop-down that shows TRUE/FALSE, but it’s not a clickable checkbox. For a true checkbox, you need the Developer tab. Alternatively, use the newer “Insert > Checkbox” feature in Excel for Microsoft 365 (available since 2023) which doesn’t require the Developer tab.

Can I make a checklist in Excel for the web?

Yes, but form control checkboxes are not supported. You can use the native checkbox feature (Insert > Checkbox) in Excel for the web if you have a Microsoft 365 subscription. Otherwise, use a data validation drop-down with “Yes/No” or “Done/Not Done” as a workaround.

How do I count how many items are checked?

If your checkboxes are linked to helper cells (e.g., C2:C10), use =COUNTIF(C2:C10,TRUE). To get a percentage, divide by =COUNTA(C2:C10) and format as percent.

Why does my checkbox move when I sort or filter the list?

Form control checkboxes are floating objects, so they don’t stay attached to rows when sorting. To keep them aligned, use the native checkbox feature (Excel 365) or switch to a data validation drop-down. If you must use form controls, avoid sorting the range.

Can I create a checklist that automatically sends an email when complete?

Not without VBA. You can write a macro that checks if all helper cells are TRUE and then uses MailEnvelope or Application.FollowHyperlink to open an email draft. Remember to save a copy of your workbook before running any macro, as macros cannot be undone with Ctrl+Z.

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.