How to Make a Checklist in Excel (Step by Step)

Search interest for how to make a checklist in excel is huge because the product already sits on most work PCs — and because paper lists do not sort, filter, or share cleanly. This guide builds a working checklist: tasks, interactive boxes, progress percentage, and strikethrough on completed rows. For choosing a ready daily task checklist excel template, use the selection hub.

Set up the sheet before you add boxes

Minimal checklist layout

1. Open a blank workbook and rename the sheet to Checklist or Today.
2. In row 1, add headers: Done, Task, Priority, Notes (add Due Date if you need it).
3. Type tasks starting in row 2 under Task — one action per row.
4. Leave the Done column empty for checkboxes.
5. Freeze the header row so long lists stay navigable.

Toggl’s checklist walkthrough stresses naming the sheet and saving early. That advice still prevents the classic “Untitled workbook” loss after you finally get Form Controls working.

Method A — Insert → Checkbox (modern Excel)

Microsoft Support documents the simple path:

Insert checkboxes

1. Select the empty Done cells next to your tasks.
2. Go to Insert → Checkbox.
3. Click a box to toggle. Checked cells hold TRUE; unchecked hold FALSE.
4. Reference a box in a formula, for example =IF(A2,"Done","Open").
5. To remove boxes, select them and press Delete (unchecked boxes remove; checked ones may uncheck first).

Method B — Developer Form Controls (classic)

If Insert → Checkbox is missing, enable Developer: File → Options → Customize Ribbon → check Developer.

Form Control checkboxes

1. Developer → Insert → Check Box (Form Control).
2. Draw the box in the Done cell; delete the default caption text.
3. Right-click → Format Control → Cell link → point to a helper cell (or the same cell if your version allows).
4. Copy the control down the list; verify each link targets the correct row.
5. Use the linked TRUE/FALSE cells for formulas — not the floating shape alone.

Older tutorials (Indeed, Zenkit, Someka) still teach this path. It works, but linked cells are easy to break when you insert rows — another reason teams eventually prefer a maintained template.

Progress percentage and strikethrough

Progress + formatting

1. Progress cell example: =IFERROR(COUNTIF(A2:A50,TRUE)/COUNTA(B2:B50),0) then format as %.
2. Select task text → Home → Conditional Formatting → New Rule → Use a formula.
3. Formula example: =$A2=TRUE (adjust to your first checkbox cell).
4. Format → Font → Strikethrough (and optional gray color).
5. Apply; test by checking and unchecking a few rows.

Carry-forward rules live on the pillar page — this article stays on build mechanics.

Word vs Excel for checklists

Word wins for printable one-off forms. Excel wins when you need filters, priority sorts, shared editing, or formulas. If you only need a wedding packing list once, Word is fine. If you run the same checklist every weekday, Excel (or a structured daily workbook) is the better home.

When to stop DIY and use a template

DIY is perfect for learning and tiny lists. Switch to a structured file when you rebuild the same columns weekly, need Start Here notes for teammates, or want pending vs complete logic already tested. PlanoNest’s Daily Task Checklist Excel Template is sold as a one-time purchase with instant download — see the product page for live pricing. Broader buying criteria sit on the pillar guide.

For checkbox-focused template shopping, continue to Excel Checklist Template with Checkbox.

Keep the list honest for a full week

A daily checklist only helps if tomorrow’s sheet does not inherit yesterday’s guilt. Archive completed rows, carry forward only true leftovers, and rewrite priorities against the calendar — not against a growing pile of unchecked boxes. If the same item rolls three days in a row, split it or schedule a real block of time. That habit matters more than another formula.

Teams that share one workbook should agree on status words (Done, Waiting, Blocked) and who may clear someone else’s checkbox. Ambiguous status is how “almost finished” becomes invisible work. A short legend on the Start Here sheet prevents that drift.

When you print a day plan for a standup, hide helper columns and print only Task, Owner, and Priority. Screen and paper can show different views of the same data — that is a feature of Excel, not a failure of the template.

Make the spreadsheet boring on purpose

Fancy dashboards feel productive and then go stale. A durable checklist workbook is slightly boring: stable headers, predictable status words, and a Done column that always means the same thing. Resist the urge to add sparkline art or five priority colors unless your team already uses that language in standups.

Name files with dates or week numbers when you archive. “Final_v7_REAL” is not a system. If you need history for performance conversations, keep weekly snapshots in a read-only folder instead of forever-growing tabs.

Mobile editing is a bonus, not the design center. Optimize for the laptop review you actually do, then confirm Google Sheets or Excel Online behavior if someone must check a box from a phone.

Troubleshooting common checklist friction

Checkboxes jump when you sort. Prefer cell-based Insert → Checkbox values, or sort carefully after verifying Form Control links. If shapes drift, recreate the Done column rather than fighting orphaned controls.

Everyone invents new Status text. Lock a data-validation list: Open, Waiting, Blocked, Done. Free text status destroys filters.

The list is never empty. That is normal. Empty is not the goal — honest prioritization is. Celebrate clearing Must Move items, not achieving inbox zero theater.

Formulas break after a teammate pasted values. Protect progress cells and document which columns are inputs. A one-line note on Start Here saves a Friday firefight.

Frequently Asked Questions

How do I create checkboxes without the Developer tab?

Use Insert → Checkbox on supported Excel versions. If the command is missing, enable Developer or update Office.

How do I count completed tasks?

Use COUNTIF on the TRUE/FALSE checkbox column, for example =COUNTIF(A2:A100,TRUE).

Can I make completed tasks disappear?

Yes — filter the Done column for FALSE only, or use conditional formatting to mute completed rows while keeping them for history.

Is Excel better than a paper checklist?

For recurring work, yes: sorting, sharing, and progress formulas beat rewriting paper. For a one-time grocery run, paper can still win on speed.

Where do I find a ready daily checklist workbook?

Start with free galleries if you are experimenting, then evaluate a structured paid workbook when the layout must survive real workweeks — details on the daily checklist hub.

Keep the list honest for a full week

A daily checklist only helps if tomorrow’s sheet does not inherit yesterday’s guilt. Archive completed rows, carry forward only true leftovers, and rewrite priorities against the calendar — not against a growing pile of unchecked boxes. If the same item rolls three days in a row, split it or schedule a real block of time. That habit matters more than another formula.

Teams that share one workbook should agree on status words (Done, Waiting, Blocked) and who may clear someone else’s checkbox. Ambiguous status is how “almost finished” becomes invisible work. A short legend on the Start Here sheet prevents that drift.

When you print a day plan for a standup, hide helper columns and print only Task, Owner, and Priority. Screen and paper can show different views of the same data — that is a feature of Excel, not a failure of the template.

Make the spreadsheet boring on purpose

Fancy dashboards feel productive and then go stale. A durable checklist workbook is slightly boring: stable headers, predictable status words, and a Done column that always means the same thing. Resist the urge to add sparkline art or five priority colors unless your team already uses that language in standups.

Name files with dates or week numbers when you archive. “Final_v7_REAL” is not a system. If you need history for performance conversations, keep weekly snapshots in a read-only folder instead of forever-growing tabs.

Mobile editing is a bonus, not the design center. Optimize for the laptop review you actually do, then confirm Google Sheets or Excel Online behavior if someone must check a box from a phone.