How to see what changed in your Excel spreadsheet (and who changed it)

Has something in your Excel spreadsheet changed—but you’re not sure what, when, or who did it? The old “Track Changes” button used to handle this, but modern Excel takes a different approach. Instead of a single feature, Microsoft now uses a set of cloud-based tools that let you trace edits, view past versions, and understand exactly what happened—provided you know where to look.

Why the old Track Changes feature disappeared

Modern collaboration requires a cloud-first approach

If you spent years relying on the legacy “Shared Workbook” tool, you’ll likely remember the annoying file corruption issues and the nightmare of trying to merge conflicting changes. Microsoft eventually realized that this old method—saving a local log of edits directly inside a file—couldn’t keep up with real-time collaboration.

The legacy feature was built for a time when people took turns with a file, checking it in and out like a library book. Today, however, Excel expects you to work simultaneously. Because of this shift, it relies on cloud-based tools for tracking and understanding changes, rather than a single built-in feature.

Use Version History to restore earlier work

Recovering data from past workbook snapshots

The most powerful tool in Excel’s modern feature set is Version History. If something in your spreadsheet suddenly changes and you can’t explain why, this is often the first place to look. In older versions of Excel, recovering from a bad edit meant relying on manual backups, but now, Excel automatically saves snapshots of your workbook over time.

When you click the file name at the top of the window and select Version History, you’ll see a side pane showing a chronological list of saved versions. Each entry includes when the version was saved and, in collaborative files, who made the changes. You can then click one of the versions to open it in a separate window, inspect it, copy missing data, or restore the entire file to that point in time.

This is especially useful when you’re trying to answer the question: “What changed in my Excel spreadsheet, and when did it happen?” It removes much of the uncertainty that comes with collaborative or iterative editing.

OS

Windows, macOS, iPhone, iPad, Android

Free trial

1 month

Microsoft 365 includes access to Office apps like Word, Excel, and PowerPoint on up to five devices, 1 TB of OneDrive storage, and more.

Use Show Changes to track specific edits

Granular auditing for specific cells and ranges

While Version History helps you step back through major spreadsheet snapshots, the Show Changes tool gives you a much more detailed view of what actually happened inside an Excel worksheet.

You can find Show Changes in the Review tab. When opened, it displays a log of recent edits—typically up to the last 60 days—showing exactly which cell was changed, what the previous value was, what it became, and who made the change.

If something in your spreadsheet looks “off,” this is the fastest way to trace it back to its source. You can also filter changes by selecting a specific range and right-clicking to view only edits that affect those cells.

Use Sheet Views to control filters and views

Filtering data without disrupting anyone else

Sometimes the issue isn’t that the data has changed in Excel—it’s that someone changed how they’re viewing it. Filters and sorts are a common source of confusion (and frustration) in shared Excel workbooks, especially when multiple people are working at the same time.

In earlier versions of Excel, applying a filter affected everyone viewing the file, which often created the impression that the data had been changed when it hadn’t. Excel for Microsoft 365 solves this problem with Sheet Views.

In the View tab, look for the Sheet View group, then click New to isolate your filters and sorts to your session. The column headers change to black or dark gray to indicate you’re working in a personal view, and you can save named views for different analysis scenarios. You can switch or exit views from the same Sheet View menu.

This removes an entire category of confusion—situations where it looks like someone changed your spreadsheet, when in reality, they only changed how they were viewing it.

Related

Steal this simple developer trick to make your next shared Excel file foolproof

A simple README tab can guide users, document data, and make your shared Excel workbooks much easier to use.

Building a conversation around your data

Sometimes the most important part of a change in Excel isn’t the change itself—it’s the reason behind it. That’s where Excel’s Comments feature comes in.

You’ll find the Comments group in Excel’s Review tab. Unlike legacy notes, modern threaded comments in Excel are designed for real-time collaboration, adding replies, mentions, and notifications to cell-based annotations. You can @mention colleagues to ask why a value was changed, and they’ll receive a notification linking directly to that exact location in the workbook.

This creates a built-in record of why changes were made. Instead of guessing why something changed or digging through emails or chat history, the reasoning is stored right alongside the data.

These comments are saved within the workbook and persist over time, giving you a lightweight audit trail of decisions and discussions. When an issue is resolved, you can mark the thread as Resolved to keep the sheet clean while preserving the history.

Excel’s modern auditing tools make it much easier to understand what happened in your spreadsheet and how it changed over time. Instead of relying on a single legacy feature, you now have a full set of tools that work together to give you visibility and control over your data.

But while Excel’s auditing tools are usually enough to explain what changed in your spreadsheet, they won’t always save you when things go badly wrong. For situations where data is lost, overwritten, or completely missing, you’ll need to step up to Excel’s recovery features to bring your work back.