How to Make a To Do List in Excel (Step by Step)
Build a DIY Excel to-do list: columns, dropdown status, checkboxes, conditional formatting, and a reusable Table.
You do not need a specialty app to keep a to do list in Excel. A blank workbook, five thoughtful columns, status dropdowns, and optional checkboxes will beat another abandoned productivity login — if you build the sheet in the right order.
For the full selection guide, see Excel to do list template hub.
Key takeaway: Build headers Task → Priority → Due Date → Status → Notes, convert to a Table, add Data Validation for status and priority, then filter daily. Optional checkboxes and strikethrough are polish, not the foundation.
Before you type headers
Decide one list per workbook (or one sheet per life area). Mixing personal errands, client deliverables, and packing steps on the same unsorted grid creates noise. Rename the tab ToDoList. Keep a second sheet named Lists for dropdown sources.
Gather: the five tasks that actually matter this week, any hard due dates, and the status words you will allow (keep the set short).
Set up the columns
Create a DIY Excel to-do list
- Open a new workbook and bold row 1 headers: Task | Priority | Due Date | Status | Notes.
- Format Due Date as Date; leave Task and Notes as text.
- Enter 5–10 real tasks — verb + object (“Draft Q3 outline,” not “Project”).
- Convert to Table — select the range and press
Ctrl+T(check “My table has headers”). Name the tableToDoList. - Add Priority dropdown — select the Priority column body → Data → Data Validation → List → Source:
High,Medium,Low(or point to Lists!A:A later). - Add Status dropdown — Source:
Not started,In progress,Waiting,Done. - Turn on Filters if the Table did not already — use them to hide Done at end of day.
- Freeze the header row so labels stay visible while scrolling.
This mirrors the structure taught in guides such as Monday.com’s Excel to-do walkthrough and Taskade’s column setup: headers first, validation second, polish third.
Optional checkboxes and strikethrough
Modern Excel often supports Insert → Checkbox on a Done column. Older workflows use Developer → Form Controls. Journal of Accountancy’s checkbox + SORT/FILTER patterns show how TRUE/FALSE can drive dynamic views — useful once the basic list already works.
For strikethrough when Status = Done:
- Select the Task column body.
- Home → Conditional Formatting → New Rule → Use a formula.
- Formula example if Status is column D and first data row is 2:
=$D2="Done". - Format → Font → Strikethrough (and a muted color).
Warning: Do not spend an hour on checkbox Form Controls before your status words are consistent. Inconsistent status kills filters faster than missing checkboxes.
Daily habits after the build
- Morning: filter Priority = High and Status ≠ Done.
- Capture new tasks in the Table footer so formatting inherits.
- Afternoon: mark Done; do not delete rows until weekly archive.
- Weekly: copy Done rows to an Archive sheet; clear them from the working table.
Make the Table survive real editing
After you create the Excel Table, type one new task in the blank row under the last entry and confirm the Table border expands. That single test catches most DIY failures before you invest in conditional formatting. Name the Table something obvious such as ToDoList so formulas and filters stay readable six weeks later. If the border does not expand, you typed outside the Table — drag the resize handle at the lower-right corner until new rows inherit formatting and validation.
Keep checkboxes and Status from fighting
If you add Form Control or Developer checkboxes, decide whether Done lives in the checkbox or in the Status dropdown — not both with conflicting meanings. Many builders use Status for workflow (Waiting, In progress) and reserve a checkbox only for binary personal habits. Write the rule in a one-line note on the Lists sheet so a future you (or a teammate) does not invent a third Done state.
Priority without theater
Priority only works when High is scarce. Cap open High items at three for personal lists. Everything else is Medium or Low until a High slot frees. If you feel anxious leaving items as Medium, that is a capacity problem — not a formatting problem. Excel cannot manufacture more hours; it can only show the tradeoff.
Notes that stay useful
Use Notes for a URL, a blocker name, or the next microscopic action. Do not write essays. When Notes grow past two lines, the row is usually a project in disguise: split it into smaller to-dos or move the milestone to a project tracker and leave a single next-action row here.
When DIY stops being fun
If you rebuild validation every month, or teammates paste over dropdowns, switch to a structured template with a Lists sheet and Start Here notes. The Download To Do List Template Excel from PlanoNest (disclosure: we sell it) is a one-time-purchase workbook with ToDoList and Lists sheets — instant digital download, no subscription. Check the product page for current pricing.
For free-file pitfalls, see Free To Do List Template Excel. For deeper dropdown technique, see How to Add a Drop-Down List to an Excel To-Do List.
Keep scope honest
This guide is for personal and small-team to-dos. It is not a delivery packing checklist, not a school calendar, and not a timesheet. If a row needs hours logged, put duration on a separate time log. If a row is a multi-week milestone, put it on a project tracker and leave a to-do that says “Next action: …”
Column philosophy matches the hub — Task, Priority, Due, Status, Notes — without re-litigating free vs paid galleries here.[/DEDUP]
Operating note before you close the file
Clear filters so tomorrow’s open does not hide High tasks. Leave Status words stable; change Due dates when reality changes. That small discipline is what separates a living to-do list from a decorative spreadsheet you stop trusting after two busy weeks.
Keep language concrete under pressure
When a task stalls, write the blocker in Notes instead of inventing a new priority level. Priority inflation is how every row turns red and none of them get finished before lunch. A blocked task with a named owner of the blocker is still useful data; a vague High item is not.
Agree on Status words early
If you collaborate with one other person, agree on Status words in a short written note inside the workbook. A thirty-second legend prevents a week of filter arguments. Put the legend on the Lists sheet beside the dropdown sources and resist adding synonyms like Complete beside Done.
Archive finished work monthly
Archive is not failure. Moving Done rows off the working table keeps attention on what can still change. Monthly archive sheets also make it easy to answer what you actually finished without scrolling a thousand-line monster. Name archive tabs by month so searches stay boring and reliable.
Resist dashboard creep
A single COUNTIF for open High items is enough for most people. Charts that need weekly babysitting will be abandoned faster than a plain filtered Table. If a chart does not change a Monday decision, delete it and reclaim the space for Notes that name the next action.
Frequently Asked Questions
How do I make a to-do list in Excel with checkboxes?
Add a Done column, insert checkboxes (Insert → Checkbox or Developer Form Controls), then optionally link TRUE/FALSE cells for formulas. Status dropdowns alone are enough for many people.
Should I use one sheet or many?
One ToDoList sheet plus a Lists sheet covers most solo use. Split sheets only when life areas truly never share filters.
Can Google Sheets do the same?
Yes for Tables-like ranges, data validation, and filters. Checkbox UI differs; re-test formatting after upload.
Do I need conditional formatting?
Helpful, not mandatory. Consistent Status values matter more than color.
What if paste removes my dropdowns?
Re-select the Status column body and re-apply Data Validation from the Lists sheet. Teach teammates to paste with formatting, or paste into Notes only.
