Checklist in Excel: Meaning, Setup, and Useful Formulas

Formulas & functions · Updated November 22, 2026

In Excel, a checklist is a list of tasks or items paired with a way to mark each one complete, usually with a checkbox or a status value. In Microsoft 365 for Windows, select the cells where you want checkboxes and choose Insert > Checkbox; Excel stores each checkbox as TRUE when selected and FALSE when cleared.

What a checklist means in Excel

A checklist is a practical worksheet layout, not a special Excel file type or a single built-in checklist command. It combines ordinary cells, such as task names and due dates, with a field that records whether each task is done. That makes it possible to review progress, sort or filter the work, and calculate completion totals.

A simple checklist might have a task in column A and a checkbox in column B. For example, a project handoff list could include “Confirm final files,” “Approve the schedule,” and “Send the client update.” Marking a checkbox records the state of each item in the workbook. The same structure can be used for a packing list, a recurring maintenance routine, a classroom assignment tracker, or a quality-control review.

The key distinction is that a checklist records status; it does not automatically verify that the underlying work was done correctly. A checked item means someone has marked it complete. If a process needs evidence, add a separate column for a reviewer, completion date, reference number, or notes.

Choose a checklist style

For a small list, in-cell checkboxes are usually the clearest choice in current Microsoft 365 versions. They sit inside worksheet cells and return TRUE or FALSE, so formulas and conditional formatting can use their state directly. They are useful when you want a compact list that can also be counted or summarized.

A status column is a good alternative when the list needs more than two states. Enter values such as Not started, In progress, Blocked, and Done, or create a drop-down list with Data > Data Validation. This makes the distinction between unfinished and actively underway work explicit. A checkbox alone only represents checked or unchecked.

Older workbooks may use floating Form Control checkboxes. Those are objects placed over the worksheet grid, rather than values stored directly in cells. They remain useful for compatibility or for a workbook built around them, but they can be harder to align and manage in a long, changing table. Avoid mixing several checkbox styles in one list unless there is a clear reason.

Add in-cell checkboxes in Microsoft 365

In Excel for Microsoft 365 on Windows, arrange the list first, then add checkboxes to the cells that will hold completion status:

  1. Enter one task per row, such as in A2:A6, and leave the neighboring cells in column B for completion status.
  2. Select the status cells, for example B2:B6. Selecting a range lets Excel add a checkbox to each selected cell.
  3. Choose Insert > Checkbox. If the command is available, checkboxes appear in the selected cells.
  4. Click a checkbox to mark the item complete, or click it again to clear it. You can also copy a cell containing a checkbox to extend the layout.

Excel treats these checkboxes as cell content, not as floating shapes. A selected box evaluates to TRUE and an empty box evaluates to FALSE. That is why an ordinary formula can count the completed items without linking each box to a separate helper cell. If Insert > Checkbox is missing, your Excel update or release channel may not yet include the feature; update Office if appropriate or use a Form Control checkbox instead.

In Excel for the web, in-cell checkbox support may also be available, but the exact interface and rollout can differ. Excel for Mac can have the feature in current Microsoft 365 builds too; if the command is absent, use a supported desktop build or the Form Controls approach. A workbook containing ordinary TRUE/FALSE checkbox cells can still be useful on systems where the checkbox display is unavailable, because the underlying values are cell data.

Use older Form Control checkboxes

Form Control checkboxes are the traditional option in desktop Excel. On Windows, enable the Developer tab if it is not visible by going to File > Options > Customize Ribbon and checking Developer. Then choose Developer > Insert > Check Box under Form Controls, click the sheet to place it, and edit or remove its caption as needed.

To make a Form Control checkbox feed a worksheet cell, right-click the checkbox, choose Format Control, open the Control tab, and set Cell link to a cell such as B2. The linked cell returns TRUE when selected and FALSE when cleared. Repeat the process for other boxes, using a different linked cell for each one. This extra link is important: without it, a traditional checkbox may look interactive but will not provide a convenient cell value for formulas.

Form Controls are positioned over cells, so row height changes, sorting, and copying can affect how they line up with task names. Set their properties and test the behavior before distributing the workbook. On Mac, the Developer tab and available control options can differ by Excel version; use the controls exposed in that installation rather than assuming the Windows ribbon is identical.

Count completed tasks and calculate progress

Once each task has a checkbox, a summary can show how many items are complete. With task names in A2:A6 and in-cell checkboxes in B2:B6, enter this formula in another cell, such as B8:

=COUNTIF(B2:B6,TRUE)

If three of the five checkboxes are selected, the result is 3. COUNTIF checks the status range for TRUE values, so it works with in-cell checkboxes and with Form Control checkboxes that are linked to those cells.

You can also calculate the share of listed tasks that are complete. With task names in A2:A6 and checkbox values in B2:B6, enter this formula in another cell:

=IFERROR(COUNTIF(B2:B6,TRUE)/COUNTA(A2:A6),0)

With three checked boxes and five nonblank task names, the result is 0.6, which can be displayed as 60% by applying Percentage format. COUNTA counts the nonblank task names, while IFERROR returns zero if there are no tasks and the division would otherwise fail. Keep the task and checkbox ranges aligned so the count reflects the same set of rows.

Make the checklist easier to read and maintain

Useful checklist columns depend on the work, but a common layout is Task, Complete, Owner, Due date, and Notes. Freeze the header row if the list is long, use a clear date format, and keep one task per row. If several people will update the sheet, explain what counts as complete and who is responsible for changing the status.

Conditional formatting can visually distinguish completed tasks. For a range with task names in A2:A20 and checkboxes in B2:B20, select A2:A20 and choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Use the rule formula =$B2=TRUE and choose a subdued fill or font style. The dollar sign fixes the status column while the row number adjusts for each task. Test the rule on a checked and unchecked row before applying it to a larger range.

For a reusable checklist, keep a clean template sheet and make a copy for each new project or cycle. In a shared workbook, avoid placing summaries or notes in the middle of the task range, since this can complicate sorting and formulas. If the list will grow, convert the range to an Excel table with Insert > Table; tables make it easier to filter and extend structured lists, though checkbox behavior should be checked after adding rows.

Common problems and useful distinctions

A checkbox that cannot be counted often has a different cause depending on its type. In-cell checkboxes provide TRUE or FALSE directly. A Form Control checkbox needs a linked cell before a formula can use its state. Also check that the formula range covers the linked cells and that there are no unrelated values mixed into the status column.

Checkboxes may shift away from their labels when someone sorts data or adjusts rows, especially when using older floating controls. In-cell checkboxes avoid that object-alignment problem because they belong to cells. If a legacy workbook relies on Form Controls, test sorting and filtering on a copy before changing the main list.

Another common misconception is that a checkbox automatically makes a task list a workflow system. It does not assign work, send reminders, establish approval rules, or preserve a reliable audit trail by itself. Add owner, due-date, and evidence fields when those details matter, and use a dedicated project or process tool if the requirements exceed what a worksheet can manage comfortably.

Frequently Asked Questions

What does a checkbox mean in Excel?
A checkbox is a visual control for marking a choice or task complete. With current in-cell checkboxes, the cell value is TRUE when checked and FALSE when unchecked.

How do I make a checklist in Excel?
Put each task in a row, select the adjacent status cells, and choose Insert > Checkbox in a supported Microsoft 365 version. Add columns such as owner or due date if the list needs them.

Can Excel count checked boxes?
Yes. For in-cell checkboxes in B2:B6, =COUNTIF(B2:B6,TRUE) counts checked items. For older Form Control checkboxes, link each one to a cell first.

Why can’t I see Insert > Checkbox?
The feature may not be included in your installed Excel build or update channel. Check for Office updates; if the command remains unavailable, use Developer > Insert > Check Box under Form Controls in desktop Excel.

Can a checklist have statuses other than complete and incomplete?
Yes. Use a status column with values such as Not started, In progress, and Done, optionally controlled by Data Validation. A checkbox is simpler when only two states are needed.

Which approach should you use?

Use in-cell checkboxes for a straightforward two-state checklist when your Excel version supports them. Choose a status column for multi-stage work, and use linked Form Control checkboxes when maintaining an older workbook or when those controls are already part of its design. Whichever method you choose, keep one task per row, make the completion rule clear, and test a summary formula against known checked items before relying on it.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.