Yes. In Microsoft Excel for Microsoft 365 on Windows, select the cells where you want checkboxes and choose Insert > Checkbox; then enter one task per row and tick items as they are finished. The checkboxes store TRUE or FALSE values, so you can also calculate progress or use those values in other worksheet features.
What an Excel checklist can do
An Excel checklist is a worksheet that pairs tasks with a way to mark their status. A simple version may have just two columns: a task name and a checkbox. A more useful work or household list can include an owner, due date, priority, category, and notes. Excel is particularly helpful when a list needs sorting, filtering, calculations, or room for additional information.
There is no single required layout. For example, a weekly home-maintenance list might have columns for Task, Due date, Done, and Notes. A project list might add Owner and Priority. Keeping one task per row makes it easier to sort the list and see what is outstanding. Avoid merging cells in the task table; merged cells can make sorting and filtering less predictable.
Excel’s newer in-cell checkboxes are different from floating checkbox controls. An in-cell checkbox sits in a worksheet cell and has a TRUE or FALSE value. Older Form Control checkboxes are objects placed over the sheet; they can be linked to cells, but require extra setup to use their state in formulas.
How to add checkboxes in Microsoft 365
For a small checklist, start with a blank worksheet and give the columns clear headings. In this example, tasks go in column A and checkboxes go in column B:
- Type a heading such as Task in A1 and Done in B1.
- Enter each task in a separate cell, starting at A2.
- Select the corresponding blank cells in column B, such as B2:B11.
- On the ribbon, choose Insert > Checkbox. Excel adds a checkbox to each selected cell.
- Click a checkbox to mark its task complete. Click it again to clear it.
In some Microsoft 365 installations, the checkbox command may not appear because the feature has not reached that installation or the app is not up to date. Update Office and check again. If it is still unavailable, use a status dropdown or a Form Control checkbox as described below. Excel for the web also supports in-cell checkboxes in versions where the feature is available, though the ribbon layout can differ. On Mac, the command may be available in current Microsoft 365 builds; if it is missing, update Excel and use a dropdown or Form Control alternative.
After making the list, widen the task column so entries are readable. You can select the data and choose Home > Format as Table to make a structured, filterable list. If you convert the range to a table, include the column headings but not a separate title row. Tables can expand as you add tasks, and their filter buttons make it easier to display only incomplete items.
Plan a layout that is easy to maintain
A checklist is only useful if people can tell what each row means. Use concise, action-based task names such as “Send the draft to Maya” rather than a broad label such as “Draft.” For recurring work, decide whether each new cycle gets a fresh list or whether you will reset the same checkboxes. Reusing one sheet without recording dates can make it unclear which week a completed item belongs to.
Choose columns based on decisions you actually need to make. A due date is helpful if timing matters; an owner is useful when several people share the work. If the list will be reviewed by others, include a notes column for context rather than putting several unrelated tasks into one cell. Use Excel’s date format for due dates, and keep priorities consistent—for example, High, Medium, and Low—so filtering returns meaningful groups.
- Personal list: Task, Done, and perhaps Due date.
- Team tracker: Task, Owner, Due date, Priority, Status, and Notes.
- Inspection list: Checkpoint, Result, Follow-up needed, and Inspector or date.
For larger or shared lists, consider turning the range into a table before adding many rows. Use descriptive, unique column headings, and avoid blank rows inside the table. These choices help Excel handle sorting, filters, and later edits without separating a task from its status.
Calculate checklist progress
Because in-cell checkboxes hold TRUE or FALSE, Excel can count completed tasks. Suppose task names are in A2:A6 and their checkboxes are in B2:B6. If three checkboxes are ticked, the completion percentage formula is =IFERROR(COUNTIF(B2:B6,TRUE)/COUNTA(A2:A6),0). It returns 0.6, which displays as 60% when the result cell is formatted as a percentage. The IFERROR wrapper returns zero rather than an error if there are no task names yet.
To show a count instead of a percentage, with the same task and checkbox layout, use =COUNTIF(B2:B6,TRUE)&" of "&COUNTA(A2:A6)&" complete". With three checked boxes and five task names, the result is “3 of 5 complete.” The count formula is a text label, so it is convenient for a dashboard cell but is not itself a numeric value for further calculations.
These examples assume every row in A2:A6 contains a task and every corresponding cell in B2:B6 contains an in-cell checkbox. If your list has blank rows, adjust the ranges or organize the tasks in a table so the denominator does not count empty task cells. If your workbook uses older Form Control checkboxes instead, these formulas will not automatically read the checkbox objects; each control needs a linked cell, and the formulas must count the linked cells instead.
Format and filter the list
Formatting helps people scan a checklist, but it should not be the only way to understand status. Keep the checkbox or a written status visible, use clear headings, and apply color sparingly. You can use Home > Conditional Formatting to highlight dates or status values, but make sure the rule refers to the correct rows and columns. For example, a rule that colors an entire row should use a consistent status column and an appropriate relative row reference.
When the list is an Excel table, use the heading filters to show only unchecked tasks, a particular owner, or items due in a chosen period. Sorting is also useful, but sort the full table rather than a single column. Sorting only the task names can detach them from their checkboxes, owners, or due dates. Before applying a sort, confirm that Excel recognizes the table as one connected range.
For a printed checklist, consider whether an on-screen checkbox will print clearly on the intended printer. Set a print area if the worksheet includes other material, and use Page Layout controls to check orientation and scaling. A paper copy cannot update the workbook when someone marks it by hand; a person must enter those changes back into the file.
Common problems and practical fixes
- The checkbox command is missing: Confirm that you are using a current Microsoft 365 version and check for Office updates. If it remains unavailable, use a dropdown list or a Form Control checkbox.
- The progress formula shows the wrong result: Check that it counts the checkbox cells, not the task names, and that its ranges include the same rows. Confirm that the checkboxes are in-cell controls or that legacy controls have linked cells.
- Tasks and checkmarks no longer match: Sort or filter the whole table, not a single column. Keep headings in the top row and avoid blank rows that split the data.
- The list is hard to use on a phone or when printed: Keep the number of columns manageable, make task text concise, and test the layout at the size people will actually use.
- Several people overwrite one another’s edits: Store the workbook in a supported OneDrive or SharePoint location and use Excel’s coauthoring features where available. Agree on who maintains headings and formulas.
Checkboxes do not prevent someone from changing a task, clearing a mark, or deleting a row. If accidental edits are a concern, make a backup and consider worksheet protection. Review what protection permits before enabling it: protecting a sheet can also restrict legitimate changes, and it is not a substitute for access control on a sensitive file.
Checkboxes versus dropdowns and Form Controls
In-cell checkboxes work well when each row has a simple yes-or-no state, such as done or not done. A dropdown is more suitable when tasks have several stages. To make one, select the status cells and choose Data > Data Validation; configure a list of values such as Not started, In progress, and Done. Dropdown statuses take more space and require a selection, but they describe work that a checkbox cannot.
Form Control checkboxes are a useful fallback in versions without the in-cell feature. On Windows, enable the Developer tab if necessary through File > Options > Customize Ribbon, select the Developer checkbox under Main Tabs, and choose Developer > Insert > Check Box under Form Controls. Place the control beside its task, then use its context menu to format it and link it to a worksheet cell. A linked cell reports TRUE when checked and FALSE when clear, which can be counted in formulas. These controls are floating objects, however, so copying, aligning, resizing, and maintaining many of them can take extra care.
For a short list, typing an empty box symbol or a status word can be enough, but symbols do not provide the same reliable TRUE/FALSE values as in-cell checkboxes. If the workbook needs dependable calculations, use actual checkboxes, a validated status dropdown, or a clearly documented text status rather than relying on decorative symbols.
Frequently Asked Questions
Can Excel automatically cross out a task when I check it?
Yes. Apply conditional formatting to the task-name cells using the corresponding checkbox value as the condition, then choose a strikethrough font format. Set the rule’s range carefully so each task row checks its own checkbox; otherwise, one checked item may format the wrong rows.
Can I count how many tasks are complete?
Yes. For in-cell checkboxes, COUNTIF can count cells containing TRUE. Ensure the range covers the checkbox cells and corresponds to the rows containing tasks. For Form Control checkboxes, link each control to a cell first and count those linked cells.
Can I use an Excel checklist on a phone?
Usually, yes, if the workbook is opened in a compatible Excel mobile app. The editing experience and available commands can differ from desktop Excel, so create and check the layout on the device or app people will use. A wide checklist may be awkward on a small screen.
Can multiple people update the same checklist?
They can coauthor a workbook when it is saved in a supported OneDrive or SharePoint location and opened with a compatible version of Excel. Sharing settings and organizational policies can affect access. Avoid relying on a local email attachment as the shared master, since separate copies can diverge.
Why does my checkbox formula return zero?
Check that the referenced cells are the checkbox cells and that the range includes the checked rows. A formula will not read the visual state of a floating Form Control unless it is linked to a cell. Also check that the task range used as the denominator contains the expected nonblank entries.
Choosing the simplest workable checklist
For a short personal list, a task column and in-cell checkbox column are often enough. Add due dates, owners, or notes only when they help someone decide what to do next. Use a progress formula when a summary is useful, and use a dropdown instead when tasks move through more than two meaningful stages. Before relying on the workbook, test a few rows by checking and clearing boxes, sorting the list, and confirming that any counts still make sense. That small review helps keep a convenient checklist accurate as it grows.
Related
- Cash Flow Statement Template Excel: Build and Use
- Cash Flow Projection Template Excel: Free Monthly Setup
- Cash Flow Report Template in Excel: Build and Use One
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Lowercase: Convert Text to LowercaseTo convert text to lowercase in Excel, use the LOWER function: =LOWER(A1) returns the text in cell A1…
- Excel Export to CSV: Does It Keep Cell Formatting?No. Exporting an Excel worksheet as a CSV file does not preserve cell formatting such as fonts, colors,…
- Box and Whisker Plot in Excel: Create and Read OneTo create a box and whisker plot in Excel for Microsoft 365 on Windows, put each group of…
- How to Add a Dropdown Menu in Google Sheets EasilyTo add a dropdown menu in Google Sheets, select the cell or cells, choose Insert > Dropdown (or…
- Create CD Labels in Microsoft Word: A Practical GuideYes. In Word for Microsoft 365 on Windows, start at Mailings > Labels > Options and choose a…
- Print Gridlines in Excel Without Data on a Blank SheetTo print gridlines without data in Excel for Microsoft 365 on Windows, select a blank range, set it…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.