This listicle covers ten practical ways to use Excel’s Track Changes feature, from basic editing review to advanced collaboration workflows. It’s written for spreadsheet users who want to monitor edits, audit data entry, or collaborate without losing control of their workbooks. Whether you’re a beginner or a seasoned analyst, these tips will help you leverage Track Changes effectively.
Enable Track Changes from the Review Tab
Track Changes is tucked away in the Review tab, under the Track Changes button (it looks like a small pencil). Clicking it and selecting “Highlight Changes” opens a dialog where you can turn on tracking for the entire workbook or just a specific range. This is the first step to seeing who changed what, and it’s essential for any collaborative project.
Highlight Changes on Screen
Once tracking is on, you can choose to highlight changes on screen, which puts a colored border around edited cells and a small triangle in the corner. This visual cue is immediate—you don’t have to dig through a log to see what’s been altered. It’s perfect for a quick review during a meeting or when you’re scanning a sheet for recent edits.
List Changes on a New Sheet
Instead of just highlighting, you can have Excel list all changes on a separate worksheet. This creates a detailed history with columns for the sheet name, cell reference, old value, new value, and the name of the person who made the change. This is invaluable for audits or when you need to provide a clear record of modifications to a manager or client.
Review Changes One by One
The “Review Changes” option in the Track Changes menu lets you step through each edit individually, accepting or rejecting them. This is the most controlled way to handle edits—you see each change in context and decide whether to keep it. It’s like having a conversation with the data, and it prevents accidental overwrites from slipping through.
Share a Workbook with Track Changes
Track Changes is tightly integrated with the legacy “Share Workbook” feature. When you share a workbook, multiple users can edit simultaneously, and Track Changes records every edit. This is a classic collaboration method, though it’s been largely replaced by co-authoring in Microsoft 365. Still, for users on older versions or those who need a strict audit trail, it’s a reliable option.
Use Track Changes in Excel Online
In Excel for the web, Track Changes is available as “Show Changes” under the Review tab. It doesn’t offer the same accept/reject workflow as desktop, but it does show a sidebar with a chronological list of edits. This is great for real-time collaboration, especially when you’re working with remote team members who might not have the desktop app.
Track Changes in a Table
Track Changes works with Excel Tables, but with a caveat: you can only track changes in a table if the table is on a separate worksheet, and you must turn on tracking before you create the table. Once set up, changes to table data are logged just like any other cell. This is handy for data-entry sheets where multiple people are adding rows.
Protect a Workbook with Track Changes
You can combine Track Changes with workbook protection to force users to track changes. In the Protect Workbook dialog, you can check the box for “Always show changes” and set a password. This ensures that no one can turn off tracking without the password, which is a strong control for regulated environments like finance or healthcare.
Filter Changes by User or Date
When you highlight changes or list them on a new sheet, you can filter by “When” (since a specific date) and “Who” (specific users). This is a powerful way to isolate a particular person’s edits or to see what changed since your last review. It saves time when you’re dealing with a large workbook and only need to focus on recent activity.
Turn Off Track Changes and Keep the History
If you turn off Track Changes, Excel gives you the option to “Keep the changes” or “Remove them from the workbook.” If you choose to keep them, the highlighted cells remain marked, and the history is still available in the list. This is useful when you want to stop tracking but preserve the audit trail for reference.
How to Choose
When deciding how to use Track Changes, consider your workflow and the level of control you need. If you’re collaborating in real-time, Excel Online’s Show Changes is the easiest. If you need to formally approve edits, the desktop’s accept/reject review is essential. For auditing, the “List changes on a new sheet” is your best bet. And if you’re dealing with sensitive data, combine Track Changes with protection to prevent tampering.
Frequently Asked Questions
Can I use Track Changes in Excel for Mac? Yes, but the interface is slightly different. In Excel for Mac, you’ll find Track Changes under the Review tab, and the options are similar to Windows.
Does Track Changes work with co-authoring in Microsoft 365? No, Track Changes is a legacy feature and is not available in the new co-authoring mode. Instead, you get Show Changes, which is a simpler version.
Can I track changes in a PivotTable? No, Track Changes does not work with PivotTables. It only tracks edits to cells in a worksheet.
Why is Track Changes grayed out? This usually happens when the workbook is shared or when it’s in a format that doesn’t support tracking (like .xlsb). Make sure the workbook is a regular .xlsx file and not shared in the new co-authoring mode.
How do I see who made a change? When you list changes on a new sheet, the “Who” column shows the username from Excel’s settings. That’s why it’s important to set your user name in Excel options.
Can I track changes in a protected sheet? Yes, but you need to allow editing of specific cells. If the sheet is fully protected, no one can make changes to track.
Final Thoughts
Track Changes is a powerful but sometimes overlooked feature in Excel. It’s not perfect—it can be clunky on large workbooks and is not supported in the newest collaboration tools—but it remains a reliable way to keep an eye on edits. Whether you’re a project manager, an accountant, or a data analyst, mastering Track Changes will give you greater confidence in your spreadsheets.