How to Keep Track of Tasks at Work in Excel

To keep track of tasks at work in Excel, create a table with one row per task and columns for the task, owner, due date, priority, and status. Turn on filters, update the status as work progresses, and review overdue and upcoming tasks regularly. A simple, consistently maintained tracker is often more useful than a complicated one.

What You’ll Need

Microsoft Excel for Microsoft 365 on Windows. The steps also work in recent desktop versions; Mac and web differences are noted where relevant.
A list of current tasks, with an owner, due date, and status where those details are known.
Agreement with your team about what the status labels mean and who is responsible for updating the sheet.

Step-by-Step

Decide what the tracker should cover. Before opening Excel, define its purpose. You might track your own weekly workload, a team project, or requests coming into a department. Decide what counts as a task and whether the sheet will include only active work or completed work too. For example, a team tracker might cover tasks due this month, while a personal tracker could include recurring responsibilities. A clear scope prevents the sheet becoming a catch-all list that is hard to review.
Create a workbook and add clear column headings. Open a blank workbook and enter one heading per column in row 1. A useful starting set is Task, Project, Owner, Start Date, Due Date, Priority, Status, and Notes. Add a column such as Requester or Last Updated only if you will actually use it. Keep each field separate: put the due date in its own column rather than typing it into the task description. This makes sorting, filtering, and checking dates much easier.
Convert the range to an Excel table. Select the headings and a few blank rows beneath them, then choose Insert > Table. Confirm that My table has headers is selected and choose OK. On Windows, Ctrl+T opens the Create Table dialog; on Mac, Command+T commonly opens it. Tables provide filter arrows, consistent formatting, and automatic expansion when you add rows. To change the appearance, select a table cell and use the Table Design tab. Choose a restrained style that remains readable when printed or viewed on a small screen.
Enter tasks as individual rows. Put one actionable piece of work in each row. “Prepare the client update” is easier to assign and close than “Client work.” If the work has several deliverables with different owners or due dates, split it into separate rows and, if useful, use a shared project name to group them. Avoid merged cells, blank separator rows, and multiple tasks typed into one cell; those choices interfere with filters and make updates harder to track. Use Notes for context, not as a substitute for the key fields.
Assign an owner and realistic dates. Enter one accountable owner for each task, even if other people will help. Use Excel date values in Start Date and Due Date, rather than text such as “next Friday,” so the dates can be sorted and checked. To enter a date, type it in a format Excel recognizes for your regional settings, such as 11/06/2026, and confirm the cell displays as a date. If the date is ambiguous to your team, use a format such as 6-Nov-2026: select the date cells, choose Home > Number Format, and select Short Date or another clear date format. Leave an unknown date blank and follow up rather than inventing one.
Use consistent priority and status labels. Choose a small set of priority values, such as High, Medium, and Low, and status values such as Not started, In progress, Blocked, and Done. Agree on what each status means. For instance, “Blocked” should mean the owner cannot make progress without a specific decision, resource, or response—not simply that the work is difficult. Consistent wording makes filters and summaries reliable. If your team uses different terms, use those terms instead, but avoid variations such as “In progress,” “In Progress,” and “Started” for the same state.
Add drop-down lists to reduce inconsistent entries. Select the cells in the Status column, then choose Data > Data Validation. In the dialog, set Allow to List, and enter the approved labels in Source separated by commas, for example Not started,In progress,Blocked,Done. Make sure In-cell dropdown is selected, then click OK. Repeat for Priority if useful. If you need a longer or frequently changing list, store the choices in a separate worksheet and use that range as the validation source. On Mac and Excel for the web, the Data Validation command is also under the Data tab, though the dialog layout can differ.
Make overdue and completed work easy to scan. Select the Due Date cells in the table, then choose Home > Conditional Formatting > Highlight Cells Rules > A Date Occurring. Use the available date rule to highlight dates in the past, and choose a format with readable contrast. Because this can also highlight completed tasks whose due date has passed, use the Status filter during review or choose a more tailored rule if your team is comfortable managing conditional-formatting formulas. You can also apply a different fill to the Status column using Home > Conditional Formatting. Keep the number of colors small and include status words so color is never the only signal.
Filter the table to focus on the next action. Use the filter arrow in the Status heading to hide Done tasks, or filter Owner to see one person’s work. Sort Due Date from oldest to newest to bring the nearest deadlines to the top. To see tasks for a particular project or priority, use the relevant heading’s filter. Clear filters when you want the full list again. Filters change what is visible, not what is stored, so check the filter indicators if a task appears to have disappeared.
Set up a predictable review routine. Agree on when the tracker is updated—for example, each owner updates their tasks before a Monday team check-in. During the review, confirm overdue work, tasks due soon, blocked items, and rows without owners or dates. Update the status and due date when plans change, and add a short note explaining a significant delay or dependency. Mark a task Done only when the agreed definition of complete is met. Keep completed rows in the table if you need a history; filter them out for the active-work view rather than deleting them automatically.
Save, share, and protect the working copy. Save the workbook with a recognizable name in a shared location your team can access, such as OneDrive or SharePoint, if collaboration is needed. Avoid circulating multiple email attachments as though each were the master copy. Use Excel’s sharing and access controls appropriate to your organization. If several people edit at once, agree who can change headings, validation lists, and formatting. Consider adding a separate Instructions worksheet if users need reminders about status definitions or update expectations.

Common Mistakes

Making the tracker too complicated: Many columns, elaborate scoring systems, or separate sheets for every small workstream can make updates feel like extra work. Begin with the fields needed to assign, prioritize, and complete tasks. Add a field only when it answers a real question in reviews.

Using inconsistent text or dates: Different spellings of a status split the same work into multiple filter choices. Dates entered as ordinary text may not sort chronologically. Use drop-down lists for repeated categories and check that dates behave like dates when sorted.

Leaving ownership unclear: A task assigned to “the team” can be missed because nobody knows who should update it. Name one accountable owner and record collaborators or dependencies in Notes if necessary.

Overwriting the original workbook or deleting completed work: Keep a clear master copy and agree how history should be retained. If you need a record, leave completed rows in the table and filter them out instead of removing them. For major structural changes, save a copy first.

Treating the sheet as a substitute for communication: A tracker shows recorded information; it does not automatically alert someone that a deadline changed or a task is blocked. Notify affected people directly when timing, ownership, or scope changes.

Tips

Freeze the header row so headings remain visible while scrolling: choose View > Freeze Panes > Freeze Top Row. On Mac, use the View tab and its Freeze Panes options; labels may vary slightly by version.
Keep task names short and action-oriented. Put longer background, links, and handoff details in Notes, or link to the relevant project document.
Use a single date convention across the workbook. A display such as 6-Nov-2026 reduces confusion between month-first and day-first formats.
Use filters for a focused working view, but remember to clear them before concluding that rows are missing or before sharing a view with someone else.
For recurring work, decide whether to create a new row for each occurrence. Separate rows preserve due dates and completion history better than repeatedly reusing one row.
Keep a lightweight change habit: update the owner, status, and due date when circumstances change, rather than waiting until the next formal review.

Troubleshooting

A task seems to have vanished. Check the filter arrows in the table headings. A filter may be hiding completed tasks, another owner’s work, or a project. Choose Clear Filter from the relevant heading menu, or use Data > Sort & Filter > Clear to clear filters across the sheet. Also check whether the table has expanded to include the row you added.

The dates sort in the wrong order or do not highlight. The cells may contain text rather than date values, or the workbook may interpret the entry using a different regional date format. Select a date cell and inspect the formula bar; re-enter the date in a recognized format, then apply a date number format. If conditional formatting is not behaving as expected, select a cell in the affected range and open Home > Conditional Formatting > Manage Rules. Check that the rule applies to the intended cells and that its date condition is appropriate.

The drop-down arrow or expected choices are missing. Select a cell in the Status column and open Data > Data Validation to confirm that Allow is set to List and the source contains the intended values. Check that the selected range includes the rows being edited. If you pasted data into validated cells, the pasted content may not match the approved labels; correct the text or choose a value from the list.

New rows do not have the table formatting or drop-down list. Add the row directly below the table or press Tab from the last cell of the last table row to create another row. If the table did not expand, click inside it and check Table Design > Resize Table. Confirm that the new row is included in the validated range; a separate list source should also include any newly added choices.

Two people have different versions of the tracker. Identify the agreed master file, compare any changes made in the copies, and bring valid updates into the master carefully. Do not assume that the most recently emailed file contains every change. For ongoing collaboration, use an organization-approved shared workbook location and make sure everyone opens the same file.

Frequently Asked Questions

How many columns should a work task tracker have?
Start with the essentials: task, owner, due date, priority, and status. Add project, start date, requester, or notes when those fields support a real workflow. The right size is the smallest set that lets people act and review progress.

Should I use one sheet or separate sheets for each project?
For many teams, one table with a Project column is easier to filter and maintain. Separate sheets can make sense when projects have different processes or access needs, but they make cross-project reviews and consistent updates harder.

Can Excel notify me automatically when a task is overdue?
Conditional formatting can make overdue dates visible in the workbook, but it does not by itself send a notification. For alerts, use a workflow approved by your organization, such as a suitable Microsoft 365 automation, and test it before relying on it.

Should I delete tasks once they are complete?
Usually, keep them if you need a record of delivery, decisions, or workload. Filter the Status column to hide Done tasks when focusing on active work. If the list grows too large, move older records to an archive using a documented process.

How can I stop people changing the headings or lists?
Explain which cells users should edit and consider reviewing Excel’s worksheet protection options under Review > Protect Sheet. Protection can prevent accidental edits, but it is not a substitute for file access controls or a secure record system.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.