How to Find Track Changes in Excel (and View Edits)

To find recent edits in Microsoft 365 Excel for Windows, open the workbook and select Review > Show Changes. The Changes pane lists supported cell edits with details such as who made each change, when it happened, and the previous and new values. For this history to work across collaborators, save the workbook to OneDrive or SharePoint and use a supported, shared workbook. Excel’s older feature is called Track Changes (Legacy), and it works differently.

Before you start, make sure you have permission to open the workbook and that you are looking at the correct copy. “Track Changes” can mean either the current Show Changes pane or the older legacy tools, so the steps below cover both. Show Changes is generally the best place to look for recent edits in Microsoft 365.

What You’ll Need

Microsoft Excel for Microsoft 365 on Windows for the main steps. The Show Changes feature is also available in Excel for the web and supported current versions of Excel for Mac, although buttons and menus can look slightly different.
For shared edit history, a workbook saved to OneDrive or SharePoint, with access for the people making edits. A local copy or emailed attachment may not contain the same collaboration history.
If you need the older Track Changes (Legacy) tools, Excel desktop for Windows is the most practical option. Those tools may need to be added to the ribbon and work only with the legacy shared-workbook feature.

Step-by-Step

Open the workbook you want to inspect. In Excel, open the file from its OneDrive or SharePoint location if it is shared. Check the workbook name and location at the top of the Excel window; opening a downloaded copy can leave you looking at a separate file without the shared edit history. If another person sent you a copy, ask whether it is the current shared workbook.
Open the Changes pane. On Windows, select Review > Show Changes. In Excel for the web, open the Review tab and choose Show Changes. In current Excel for Mac, look for Show Changes on the Review tab. If the button is missing, confirm that Excel is up to date and that the workbook is in a supported shared location.
Wait for the pane to load, then scan the entries. Excel displays recorded edits in a pane, usually with the most recent changes easiest to find. Each entry can identify the edited cell or range, the person who changed it, the time of the edit, and the old and new contents. The exact information depends on the change and the workbook. Select an entry to inspect it and, where supported, move to the affected cell.
Find a particular cell or area. Use the pane’s available filters to narrow the displayed changes, such as by worksheet or range. If you know the cell address, such as D14, go to that cell in the worksheet and compare it with the entries in the pane. A cell’s current value alone does not reveal its previous value; use the change entry for that information. If filters are not shown in your Excel build, scroll through the list or use the worksheet name and cell reference shown with each entry.
Check the details before acting. Compare the recorded previous value with the current or new value. For example, if a quantity changed from 12 to 21, verify that the cell and edit time match the change you are investigating. A person’s displayed name or account may identify the editor, but shared accounts and organization settings can make attribution less specific than expected.
Restore a value manually if necessary. Show Changes is an audit view, not a one-click rollback list. If an entry shows the correct earlier value, select the affected cell and enter that value again, after confirming that no later valid edit depends on it. If the edit just happened and is still the latest action in your session, Undo may work, but it can undo other actions too. For important files, make a copy before restoring data.
Look for older changes only if the workbook has legacy tracking enabled. Show Changes covers a limited recent-history window—up to 60 days—and does not provide a permanent record of every action. If you need older records, determine whether the workbook used Track Changes (Legacy) and whether its history was retained. If neither current history nor a legacy history record exists, Excel may not be able to reconstruct the edit.
Access Track Changes (Legacy) if that is what the instructions refer to. In Windows desktop Excel, select File > Options > Customize Ribbon. Under the command list, choose All Commands. Find the needed legacy commands, such as Highlight Changes (Legacy) or Accept/Reject Changes (Legacy), and add them to a custom group on the Review tab. Select OK. You may need to add Share Workbook (Legacy) as well to manage the old shared-workbook setting.
Use the legacy highlight command only for a legacy shared workbook. Select the legacy highlight command on the Review tab and set the available options for when, who, and where to look. You can choose to highlight edits on the sheet or list changes on a separate worksheet if that option is available. The legacy system depends on the old shared-workbook mode; it is separate from modern co-authoring and is not a way to turn on Show Changes for an ordinary workbook.

In Excel for the web, use Show Changes for recent supported edits; you cannot add Windows desktop ribbon commands there. On Mac, the current Show Changes view is the appropriate modern route, but legacy command availability and setup can differ from Windows. If a task specifically requires the old legacy tools, use a Windows desktop copy and check that the workbook is configured for the legacy shared-workbook feature before relying on its history.

Common Mistakes

Looking for the old “Track Changes” button on the Review tab. In current Excel, Microsoft’s modern feature is called Show Changes. The legacy commands are not normally displayed on the ribbon, so add them through Customize Ribbon if you truly need them.
Confusing version history with cell-level change details. OneDrive and SharePoint version history can help you open or restore an earlier file version. Show Changes is designed to inspect individual supported edits. They are related ways to investigate a workbook, but they are not the same view.
Assuming every action appears in the pane. Show Changes is mainly for supported cell edits. It is not a complete recording of every workbook action, and changes to formatting or other objects may not appear as the kind of old-value/new-value entry you expect.
Opening a local or downloaded copy. A copy saved to your computer may be disconnected from the shared workbook’s live history. Reopen the original file from OneDrive or SharePoint before concluding that no one made changes.
Expecting an unlimited history. Show Changes only displays recent history, up to 60 days. Do not treat it as a permanent audit log or assume that closing the pane deletes or preserves a record beyond that limit.
Turning on legacy sharing without checking the consequences. Track Changes (Legacy) relies on an older shared-workbook mode with limitations. Do not switch a production workbook to it casually; check with the file owner or organization’s Microsoft 365 administrator first.

Tips

Record the location before investigating. Note the worksheet name, cell address, and approximate time of the unexpected value. That makes it easier to match an entry to the right edit, particularly in a busy workbook.
Use the pane as evidence, not as an automatic correction. Check whether a later edit superseded the one you found. Restoring an older value without understanding the sequence can erase a valid update.
Check version history for broader recovery. If a large range, formula structure, or workbook layout changed, use the file’s OneDrive or SharePoint version history to inspect an earlier version. Make a separate copy before restoring a whole workbook version that could overwrite newer work.
Ask collaborators to use their own accounts. Individual sign-ins make the editor information more useful. If multiple people edit while signed in through one shared account, the name shown may not tell you which person made a particular change.
Keep the shared file in one agreed location. If a team edits emailed copies and later merges them, there may be no single complete change list. Agree on one OneDrive or SharePoint workbook and share its link.
Do not rely on legacy tracking for a new collaboration workflow. For ongoing co-authoring, use modern shared workbooks and Show Changes. Reserve the legacy commands for an existing file or a specific compatibility need.

Troubleshooting

Show Changes is missing or disabled: Confirm that you are using a current supported Excel version and have opened the shared file from OneDrive or SharePoint. Check that you are signed in to the account with access, then close and reopen the workbook. If the control remains unavailable, your organization’s setup or the workbook format may not support the feature.

The pane opens but has no entries: Verify that you have the right file, then check whether anyone has made recent supported cell edits. The pane cannot display edits outside its history window, and it may not list formatting or other kinds of changes. Ask a collaborator to confirm which workbook they edited and when.

The value changed, but you cannot identify who changed it: Check the entry’s editor and time, then confirm that each collaborator used an individual Microsoft account. A shared login, an offline edit, or a copied file can make the editor details incomplete or confusing. Version history may help establish which saved version contains the change.

You cannot find an older change: Show Changes is limited to up to 60 days of recent history. Check OneDrive or SharePoint version history for an earlier saved state. If the workbook was not saved in a location that retained versions and legacy tracking was not active, the exact prior cell value may no longer be recoverable.

A legacy command is not available: Make sure you added it from File > Options > Customize Ribbon using All Commands, and placed it in a custom ribbon group. Then check whether the workbook is using the legacy shared-workbook mode. The legacy tools are not a general replacement for Show Changes and may not be available in Excel for the web.

Frequently Asked Questions

Is Show Changes the same as Track Changes?
Not exactly. Show Changes is the modern Microsoft 365 feature for viewing recent supported edits in a shared workbook. Track Changes (Legacy) is an older set of commands tied to the legacy shared-workbook feature.

How far back can I see changes in Excel?
The Show Changes pane can display changes from up to 60 days. For older saved states, check OneDrive or SharePoint version history. Neither view should be assumed to be a permanent, complete audit log.

Can I see who changed a cell and what it was before?
For a supported edit in the available history, the entry can show the editor, time, cell location, and previous and new values. Attribution can be less clear if collaborators share an account or edit separate copies.

Can I use Show Changes in Excel for the web or Mac?
Yes, current supported versions of Excel for the web and Mac include the modern Show Changes feature. The interface may differ slightly from Windows. The legacy ribbon setup described above is for Windows desktop Excel.

Can I undo a change from the Changes pane?
The pane is for reviewing edits, not a general rollback control. You can enter a previous value manually after checking the edit sequence, or use Undo if the change is still the latest action in your session. For larger recoveries, inspect version history first.

Why are formatting changes not listed?
Show Changes is focused on supported cell edits and does not capture every kind of workbook activity. For broader changes, compare saved versions or ask the editor what was changed; the pane should not be treated as a complete record of formatting, objects, or every action.

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.