To make a checklist in Excel, select the cells for your tick boxes and choose Insert > Checkbox. Each box is a cell value: ticked is TRUE and unticked is FALSE, so a single formula can count what is done. Add columns for the owner and the due date, a progress percentage, and a rule that highlights finished rows, and you have a working checklist in about ten minutes.
This guide walks through each step in Excel for Microsoft 365, the older Developer-tab method for earlier versions, how to share the checklist and see who ticked what, and where a spreadsheet checklist stops being the right tool.
Before You Start
The Insert > Checkbox command is part of Excel for Microsoft 365. Microsoft's help page on checkboxes covers Windows and Mac, and the Excel team announced in June 2024 that checkboxes had also rolled out to Excel for the web and the iPad, iPhone and Android apps. If you have an older, one-time-purchase version of Excel, use the Developer tab method further down.
To share the checklist with your team and edit it together, save it to OneDrive or SharePoint. Co-authoring needs a Microsoft 365 subscription and a file stored there.
How to Make a Checklist in Excel, Step by Step
Set up the columns
Put one step of the checklist on each row and give each piece of information its own column. A layout that works for most team checklists is Done, Task, Owner, Due and Notes. Keep the tick box in the first column so it is easy to scan, and turn the range into a table (Insert > Table) if you want filters on each column.
Insert the checkboxes
Select the cells in the Done column, then choose Insert > Checkbox. Excel puts a box in every selected cell. Click a box, or select it and press the spacebar, to tick it. A ticked box has the value TRUE and an unticked box FALSE, according to Microsoft.
To remove the boxes, select them and press Delete: the first press unticks any ticked boxes, and the second removes them.
Add drop-downs for the owner or the status
A drop-down keeps names and statuses consistent. Select the Owner cells, choose Data > Data Validation, and on the Settings tab set Allow to List. For the Source, type the names separated by commas or select a range that holds them. See Microsoft's guide to creating a drop-down list.
Show progress with COUNTIF
Because a ticked box is TRUE, COUNTIF can count the done items. If your boxes are in A2:A20 and your tasks in B2:B20, this formula gives the share that is done:
=COUNTIF(A2:A20,TRUE)/COUNTA(B2:B20)Format the cell as a percentage with the Percent Style (%) button on the Home tab. Put it above the list so everyone sees it when they open the file.
Highlight the rows that are done
Select the rows of the checklist, for example A2:E20, and choose Home > Conditional Formatting > Manage Rules > New Rule. Pick Use a formula to determine which cells to format and enter:
=$A2=TRUEClick Format and choose a grey font colour or a light fill. The dollar sign before A keeps the rule looking at the tick box, whichever column it is formatting. Microsoft explains formula rules in its guide to conditional formatting.
Share it and assign the steps
Save the workbook to OneDrive or SharePoint and share it: everyone with access sees each other's changes within seconds. To give someone a step, add a comment on its row, type @ and their name, tick Assign to and post it. Microsoft says the person receives an email, and resolving the comment closes the task. Assigning needs a work or school account and a file in SharePoint or OneDrive for work or school.
An Example Checklist Layout
Here is a new-starter IT checklist laid out in the five columns above. The Due column counts days from the start date, so the same sheet works for every new starter.
| Done | Task | Owner | Due | Notes |
|---|---|---|---|---|
| ☐ | Create the user account and email address | IT | Day −3 | |
| ☐ | Order and set up the laptop | IT | Day −3 | Serial number |
| ☐ | Add to payroll | HR | Day −1 | |
| ☐ | Book the welcome meeting | Line manager | Day 1 | |
| ☐ | Grant access to shared drives and tools | IT | Day 1 | Which systems |
Older Versions of Excel: the Developer Tab
If Insert > Checkbox is not in your version of Excel, use a form-control check box instead:
- Show the Developer tab: File > Options > Customize Ribbon, then tick Developer (Microsoft's steps).
- Choose Developer > Insert and, under Form Controls, the check box (form controls).
- Draw the check box in the cell, then copy it down the column.
Form-control check boxes float over the sheet rather than living in the cell, and Microsoft notes that they can't be used in Excel for the web. If everyone on your team has Microsoft 365, the Insert > Checkbox method is simpler.
See Who Ticked What
On a shared workbook, Review > Show Changes lists edits with who made each one, where, when and the previous value. You can also right-click a cell or range to see its changes. Microsoft's help sets out the limits:
- Show Changes covers the past 365 days.
- It doesn't show formatting changes, object edits or PivotTable operations.
- Edits made in a one-time-purchase or older version of Excel aren't tracked and clear the Changes pane, as does uploading, copying or replacing the file.
For whole earlier copies of the workbook, use version history (File > Info > Version History), which works for files stored in OneDrive or SharePoint.
Where an Excel Checklist Runs Out
An Excel checklist is right for a list you run once, or for yourself. Teams usually hit the same limits when one checklist becomes a process that runs every week or for every new starter:
The five limits teams run into
- Every run is a copy. Excel doesn't start a fresh copy on a schedule. You can build one with a scheduled Power Automate flow and the OneDrive Copy file action, or copy the file by hand each time.
- An owner is a name in a column. Nobody is told when it is their turn or chased when a step is late, unless someone assigns a comment by hand.
- Any editor can tick any row. Nothing stops a step being ticked out of order, or unticked later.
- The history has limits. Show Changes keeps a year and is cleared when the file is copied or replaced.
- The answers are spread across copies. Last quarter's results live in last quarter's files.
That is the point where checklist software earns its place. In CheckFlow a template starts a fresh checklist on schedule, every task has an owner and a due date, halts keep steps in order, approvals record the decision, and every run is kept with who did what and when. Generate with AI can turn your Excel checklist into a template you can edit, and you can still export checklists and tasks to Excel. See how it compares in our Excel checklist alternative guide, or read what checklist software is.
Sources
- Microsoft Support, "Using checkboxes in Excel"
- Microsoft 365 Insider Blog, "Introducing checkboxes in Excel", June 2024, updated January 2026
- Microsoft Support, "Create a drop-down list"
- Microsoft Support, "COUNTIF function"
- Microsoft Support, "Use conditional formatting to highlight information in Excel"
- Microsoft Support, "Collaborate on Excel workbooks at the same time with co-authoring"
- Microsoft Support, "Use @mention in comments to tag someone for feedback"
- Microsoft Support, "Show the Developer tab"
- Microsoft Support, "Form controls"
- Microsoft Support, "Show changes that were made in a workbook"
- Microsoft Support, "Get help with Show Changes in Excel"
- Microsoft Support, "View previous versions of Office files"
- Microsoft Learn, "Run flows on a schedule" (Power Automate)
- Microsoft Learn, OneDrive for Business connector
Frequently Asked Questions
How do I insert a checkbox in Excel?
Select the cells where you want the boxes and choose Insert > Checkbox. This is in Excel for Microsoft 365 on Windows and Mac, and has rolled out to Excel for the web and the mobile apps. In older versions, show the Developer tab and use Developer > Insert > Form Controls > Check Box.
How do I count ticked checkboxes in Excel?
A ticked checkbox is TRUE, so =COUNTIF(A2:A20,TRUE) counts the ticked boxes in A2:A20. Divide by the number of tasks, for example =COUNTIF(A2:A20,TRUE)/COUNTA(B2:B20), and format the cell as a percentage to show progress.
How do I strike through or grey out completed rows?
Select the rows, choose Home > Conditional Formatting > Manage Rules > New Rule > Use a formula to determine which cells to format, enter =$A2=TRUE (where column A holds the boxes) and choose the formatting for done rows, such as a grey font or a light fill.
Can several people tick the same Excel checklist?
Yes. Save the workbook to OneDrive or SharePoint and share it; with Microsoft 365, people can edit it at the same time and see each other's changes within seconds. Review > Show Changes then shows who ticked what, for the past 365 days.
Can an Excel checklist repeat every week or month?
Not by itself. You can copy the file or sheet for each run, or build a scheduled Power Automate flow that copies it. If the checklist runs often and several people work on it, checklist software such as CheckFlow starts each run on schedule with the steps already assigned.
