To make a blank checklist template in Excel, add a checkbox column beside a task column, then include optional fields such as owner, due date, status, and notes. In Microsoft Excel for Microsoft 365 on Windows, select the cells for checkboxes and choose Insert > Checkbox; the template can then be reused by clearing its entries while keeping the headings and formatting.
What a blank Excel checklist template includes
A checklist is a simple table for recording items that need attention and marking which ones are complete. A blank template is the reusable structure, not a list tied to one particular project. It might be used for a packing list, a weekly cleaning routine, a work handoff, or a recurring inspection. The best layout depends on whether you only need to tick off tasks or also need to track who will do them and when.
For a basic, flexible version, use these headings:
- Done: a checkbox or status entry.
- Task: a short, specific action.
- Owner: the person responsible, if relevant.
- Due date: the date by which the task should be finished.
- Notes: details, dependencies, or completion evidence.
Keep the task field clear and action-oriented. “Confirm venue booking” is easier to act on than “Venue.” If the list is for one person and has no deadlines, the Done and Task columns may be all you need. Extra columns are useful only when they answer a real tracking question.
Build the reusable worksheet
- Open a new workbook in Excel for Microsoft 365 and rename the worksheet with a useful name, such as “Checklist Template.”
- In row 1, enter the column headings. For example, put Done in A1, Task in B1, Owner in C1, Due date in D1, and Notes in E1.
- Leave rows 2 onward available for checklist items. For a small template, format rows 1 through 21 so there is room for 20 tasks, but do not treat that number as a limit.
- Select the heading row and use Home > Bold. To keep headings visible while scrolling, select cell A2 and choose View > Freeze Panes > Freeze Panes.
- Save the workbook as an Excel Workbook (*.xlsx). Keep an untouched copy as the master, then make a copy when starting a new checklist.
Excel tables can make the task area easier to manage, particularly when lists grow. Select the heading row and a reasonable block of blank rows, then choose Insert > Table and confirm that the table has headers. Tables provide filter controls and carry formatting and formulas into added rows. For a very small, fixed checklist, a formatted range may be simpler; a table is not required just to use checkboxes.
Add checkboxes in Microsoft 365
In current Microsoft 365 builds, select the cells in the Done column where checkboxes should appear, then choose Insert > Checkbox. A checkbox appears in each selected cell. Click one to check or clear it. Excel stores the checkbox state as TRUE when checked and FALSE when unchecked, which allows formulas to count completed items. The checkbox is a cell feature rather than a floating shape, so it is generally easier to keep aligned with the task row when sorting or editing a list.
If Insert > Checkbox is not available, check that Excel is updated and that the workbook is in a format that supports the feature. In older Excel versions, use a dropdown status instead: select the status cells, choose Data > Data Validation, set Allow to List, and enter a Source such as Not started,In progress,Done. This creates a simple reusable status field without relying on checkboxes. Avoid mixing different approaches in the same column unless there is a clear reason, since formulas and filters are easier to use when entries follow one consistent pattern.
For Mac or Excel for the web, ribbon names and layout can vary slightly by release, but the checkbox feature is available in supported Microsoft 365 versions. If the Insert tab does not show Checkbox, use the status dropdown method or check the Excel version and update options. A workbook shared with someone using an older edition may not behave identically, so test the template in the version your team actually uses before distributing it.
Choose useful columns and a practical layout
Think about what a person needs to know to complete each item. A personal travel checklist might need only Task and Done, with Notes for details such as “keep medication in carry-on.” A team checklist might need Owner and Due date so the list shows who is responsible and when an item is expected. A maintenance checklist could include Location or Inspection date instead of Owner. The template should fit the work rather than forcing every checklist into the same wide format.
Use one row per independently completable task. If an item has several distinct actions, split it into separate rows when each one can be finished at a different time. Avoid merged cells within the task area: they complicate sorting, filtering, and adding rows. Keep headings short, use consistent date formats, and leave enough width for task text. If the Notes field gets long, turn on Wrap Text from Home > Wrap Text and adjust row height as needed.
For repeatable work, you can add a Category column, such as Before departure, At the site, and After return. Then a filter can show one group at a time. Do not use color alone to communicate whether a task is complete; a checkbox or written status is clearer for people who cannot distinguish the colors or who print in black and white.
Track completion with formulas
A checklist does not need formulas, but a small summary can show progress without counting rows by hand. With checkbox values in A2:A11 and task names in B2:B11, use this formula to count checked items:
=COUNTIF(A2:A11,TRUE)
If three of the ten checkboxes are checked, the result is 3. The formula counts checked boxes in the stated range; it does not decide whether a task is applicable or whether its text is complete.
With checkbox values in A2:A11 and task names in B2:B11, use this formula to calculate the share of nonblank tasks that are checked:
=IFERROR(COUNTIF(A2:A11,TRUE)/COUNTA(B2:B11),0)
For example, if eight task names are present and eight corresponding boxes are checked, the result is 1, which is 100% when the result cell is formatted as a percentage. If there are no task names, IFERROR returns 0 instead of a division error. Format a result cell with Home > Number Format > Percentage. If you add more tasks beyond row 11, expand the formula range or use a table-based design so the summary covers the intended list.
Be cautious about counting a checked box when its task cell is blank. The percentage formula above uses the number of nonblank task names as its denominator, but a checked blank row can still increase the numerator. To avoid misleading results, leave checkboxes clear on unused rows, or build the template so the calculation range contains only rows with actual task entries.
Format the checklist for everyday use
Formatting should make the sheet readable, not decorative at the expense of clarity. Use a distinct fill for the heading row, consistent fonts, and a modest amount of space between columns. Freeze the headings if the list is long. Keep the checkbox column narrow and the task column wide enough to show most entries. If dates matter, apply a consistent date format to the Due date column rather than typing dates as informal text.
For long task names, use Home > Wrap Text. For an existing table, use its filter arrows to show a particular owner, date range, or category. Conditional formatting can highlight overdue dates, but it needs a clearly defined rule and should not replace the written status. If the checklist is used by several people, include a short instruction near the top, such as “Check the box when the task is complete; enter one task per row.” Keep instructions outside the sortable task table so they do not get mistaken for an item.
Print, share, and reset the template
Before printing, use File > Print to inspect the preview. A wide checklist may need landscape orientation or a smaller scaling setting; avoid shrinking text so much that it becomes difficult to read. Set a print area if the workbook contains unrelated notes, and repeat the header row on additional pages when the checklist spans multiple sheets of paper. Printed checkboxes can be marked by hand, but the digital checkbox state is not automatically updated by writing on paper.
For sharing, decide whether recipients need to edit the master or only use a copy. Keeping a protected master file separate from working checklists reduces the chance that someone overwrites the blank structure. If you send the workbook to users with different Excel versions, explain how to use the status dropdown if their version does not show the checkbox feature. Do not assume that a workbook’s appearance or controls will be identical across desktop, web, and older software.
To reset a completed checklist, clear the task entries and the related owner, date, and notes values while preserving headings and formatting. For a table, select only the data cells you intend to clear. Check the selection before pressing Delete; deleting whole worksheet rows can remove table structure or formulas. Save the reset file under a new name if the completed checklist is a record you need to keep.
Common problems and how to avoid them
- Checkbox command is missing: The Excel build may not support the feature or may need an update. Use a data-validation dropdown as a compatible alternative.
- Progress is wrong: Check that the formula range covers the checkbox and task rows you intended, and that unused rows are not marked complete.
- Sorting separates tasks from their checkboxes: Sort the complete table or full row range, not only one column. Sorting a single column can detach values from the tasks they describe.
- The template is hard to print: Review Print Preview, adjust orientation and scaling, and remove unnecessary columns from the print layout.
- People interpret statuses differently: Define what “Done” means and use consistent choices. For work that can be underway but not finished, a status dropdown may communicate more than a binary checkbox.
Frequently Asked Questions
Does Excel have a blank checklist template?
Excel may offer templates through its template gallery, but a custom blank checklist is easy to create with headings, task rows, and checkboxes or a status dropdown. A custom layout is often more useful when you need specific fields such as owner, due date, or notes.
How do I make a checklist in Excel without checkboxes?
Use a Status column with a data-validation list. Select the cells, choose Data > Data Validation, set Allow to List, and enter options such as Not started,In progress,Done in the Source box. Users can then select a consistent status from each cell.
Can Excel count completed checklist items?
Yes. If checkbox values are in A2:A11, =COUNTIF(A2:A11,TRUE) counts the checked boxes. The result is a number of completed items, not a percentage; divide by the number of applicable tasks if you want a completion rate.
How do I reuse a checklist without losing the original?
Keep a master workbook that stays blank, then use Save As to create a separate working copy for each project or cycle. This preserves the template and lets you retain completed checklists as records.
Can I use an Excel checklist on paper?
Yes. Set up the print area and check the preview before printing. Printed checkboxes can be marked manually, but those marks do not change the digital checkbox values in the workbook.
Related
- Excel Financial Analysis: Methods, Models, and Metrics
- Excel Export CSV With Headers: How It Works
- Excel Export CSV With Quotes: How It Works
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Mac Shortcuts: Essential Keys and How They WorkExcel for Mac uses the Command key (⌘) for many everyday shortcuts: press ⌘+C to copy, ⌘+V to…
- How to Insert Alternating Color Rows in Excel EasilyTo insert alternating color rows in Excel, select your data, choose Home > Format as Table, pick a…
- Record Data in Excel Online: Setup, Sharing and TipsYes. You can record and manage data in Excel for the web by creating a workbook in OneDrive…
- Excel Shortcut to Insert a Row Every Other Row in a ListIn Excel for Microsoft 365 on Windows, select the row header where you want a row inserted and…
- Google Sheets: Get a List of Unique ValuesWith source values in A2:A, enter =UNIQUE(A2:A) in an empty cell to return each distinct value once. This…
- How to Not Copy Hidden Cells in Excel When PastingTo copy only the cells you can see in Excel, select the range, choose Home > Find &…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.