Can You Track Changes in Excel? How Each Option Works

How-to basics · Updated November 21, 2026

Yes. In Excel for Microsoft 365, use Review > Show Changes to see recent cell edits, or use Version History to compare and restore saved copies of a cloud-stored workbook. Excel also retains a legacy Track Changes feature, but it is intended for older shared-workbook workflows.

What “Track Changes” Means in Excel Today

People use “track changes” to mean a few different things: identifying who edited a cell, reviewing a record of earlier edits, or comparing whole-file versions. Excel has separate features for these jobs, and they do not record the same information.

Show Changes is the current, cell-focused option for reviewing edits in a workbook shared through OneDrive or SharePoint. Version History keeps saved copies of the file so you can open or restore an earlier version. Track Changes (Legacy) is an older tool designed for the classic Shared Workbook feature. For most Microsoft 365 users, Show Changes and Version History are the practical choices.

These features are not a complete audit system. They can help a team understand ordinary spreadsheet edits, but they do not necessarily capture every action, preserve a permanent record, or prove why someone made a change. If a business or regulatory process requires a formal audit trail, confirm that Excel’s available history meets the requirement before relying on it.

How to Use Show Changes

In Excel for Microsoft 365 on Windows, open the workbook and select Review > Show Changes. A pane opens with recent edits. Select an entry to go to the affected cell and review details such as the editor, location, time, and previous cell value when that information is available.

  1. Save the workbook to OneDrive or SharePoint, then share it with the people who need to edit it.
  2. Open it in Excel for Microsoft 365 and choose Review > Show Changes.
  3. Use the pane’s filters, where available, to narrow the list by worksheet or cell range.
  4. Select a listed change to inspect the cell and its edit details. Use the displayed information to decide what to keep or discuss with the editor.

Show Changes is most useful when people are coauthoring the same cloud workbook. For example, if a colleague changes a forecast value from 125 to 150, the pane can identify the cell and show the previous value, helping you see what changed without scanning the entire sheet. It does not automatically approve, reject, or merge individual edits as a formal review workflow would.

Microsoft describes Show Changes as showing changes from the last 60 days. That makes it useful for recent collaboration, but not a permanent archive. The pane may not show every kind of workbook action: it is principally about changes to cell values and formulas, not a full record of formatting, layout, or every object-level edit. If you cannot find a particular action there, check Version History and consider whether the action is one that Show Changes records.

Use Version History to Review Earlier Copies

Version History answers a different question: “What did this workbook look like when it was saved earlier?” It is available for files stored in OneDrive or SharePoint, where Microsoft 365 can retain versions. In Excel, open the workbook’s version history from the file name or the file information area; the exact control can vary by app layout. You can also find the file in OneDrive or SharePoint and open its version history there.

Select an earlier version to open it separately and inspect its contents. If you need to return to that state, use the restore option carefully: restoring an old version can replace the current file state. A safer approach when you only need to retrieve a few values is to open the older version, compare the relevant cells, and copy information into the current workbook after checking it.

Version History is broader than Show Changes because it preserves a previous workbook snapshot, not just a list of cell edits. But a snapshot may not explain who changed one particular value or why. For instance, if a formula and several formatting choices changed between two saves, opening the older version lets you inspect the previous workbook, but it may take manual comparison to pinpoint every difference.

Files saved only on a local drive do not have OneDrive or SharePoint version history. If you need recoverable versions, save the workbook to a supported cloud location or make dated backup copies in a controlled folder. Avoid assuming that pressing Save creates a browseable version history for every file.

What the Legacy Track Changes Feature Does

Track Changes (Legacy) belongs to Excel’s older Shared Workbook workflow. It can record changes in a shared workbook and highlight edits, but Microsoft 365 does not present it as the normal modern collaboration method. The legacy approach has restrictions and should not be confused with the current Show Changes pane.

In current Excel for Windows, the legacy commands may need to be added to the ribbon. Go to File > Options > Customize Ribbon, set the command list to All Commands, and add the relevant legacy commands, such as Track Changes (Legacy) and Share Workbook (Legacy), to a custom group. The legacy tracking workflow depends on the old shared-workbook feature; follow the prompts in those commands and test it on a copy before using it on an important file.

This is generally a compatibility choice for an existing process, not the best starting point for a new team. Legacy shared workbooks impose limitations on workbook features and collaboration. If your group needs simultaneous editing and a recent cell-change record, use a cloud-stored workbook with modern coauthoring and Show Changes instead, provided the file and your Excel version support them.

Which Method Should You Choose?

Choose based on the question you need to answer, not just on the label “track changes.” A team that wants to review recent edits should start with Show Changes. Someone who needs to recover an earlier workbook state should use Version History. An organization maintaining an established process based on Shared Workbook (Legacy) may need the old tracking commands for compatibility.

  • “Who changed this cell recently?” Use Show Changes in a supported cloud workbook.
  • “Can I get yesterday’s workbook back?” Check Version History, then inspect or restore the appropriate version.
  • “Our existing file uses Shared Workbook (Legacy).” Check whether Track Changes (Legacy) is part of that workflow before changing collaboration methods.
  • “We need a durable audit record.” Do not assume either feature is sufficient; establish a process that meets your organization’s recordkeeping requirements.

For example, a small sales team reviewing an updated monthly target can use Show Changes to identify a recent edit and its previous value. A manager looking for the version of the budget from last Friday should use Version History. Those needs overlap, but neither tool replaces the other.

What Is and Is Not Recorded

Show Changes focuses on cell-level edits. It can be helpful for values and formulas, but it is not a keystroke log or a complete playback of someone’s work. Do not assume it captures every formatting adjustment, worksheet operation, or change to charts and other objects. The precise details shown can depend on the edit and the workbook’s collaboration history.

Also distinguish a changed formula from a changed result. If a formula remains the same but its displayed result changes because an input cell was edited, the important recorded edit may be the input cell, not a separate manual change to the result. When reviewing a calculation, inspect the related formulas and inputs rather than treating a changed displayed number as proof that someone typed over it.

Version History stores workbook states, but it does not necessarily provide a convenient cell-by-cell explanation of the difference between two states. To compare versions thoroughly, open them side by side or compare key sheets and formulas. For a small number of critical inputs, teams can also maintain a separate change log with fields such as date, editor, cell or range, old value, new value, and reason. That log is a deliberate record, not something Show Changes creates automatically.

Common Problems and Practical Safeguards

If Show Changes is missing or appears empty, first check that you opened the cloud-stored workbook in a version of Excel that supports the feature and that you have the expected access. Confirm that the file is in OneDrive or SharePoint, not merely a local folder or an emailed copy. Then check whether the change is recent and whether it is a type of edit the pane records. The 60-day history window means older edits may no longer appear there.

Excel for the web also provides collaboration features, and the Review area is the place to look for Show Changes. On Mac, the available controls can depend on the Microsoft 365 build; check the Review tab for Show Changes, or open the workbook in Excel for the web if the desktop command is unavailable. A workbook that opens in compatibility mode or uses an older file format may not behave like a modern coauthored Microsoft 365 workbook.

To reduce confusion and protect important data:

  • Keep the working file in the team’s approved OneDrive or SharePoint location rather than circulating multiple email attachments.
  • Give collaborators the access level they need and avoid sharing editable links more broadly than necessary.
  • Check Version History before making a major restoration, and preserve a copy if you may need the current state.
  • For consequential edits, record the reason and approval in a separate process; a cell history alone may not preserve that context.

Most importantly, treat the history as a review aid, not as a substitute for backups or access controls. History can help explain or recover work, but it cannot prevent a mistaken edit, and the visibility of a change does not itself make that change safe or correct.

Frequently Asked Questions

Can Excel show who changed a cell?
Yes. In a supported Microsoft 365 cloud workbook, choose Review > Show Changes. The pane can show the editor and details for recent recorded cell changes. It is not a permanent, comprehensive audit log.

How far back can I see changes in Excel?
Show Changes displays edits from the last 60 days. For saved workbook states beyond that window, check Version History if the file is stored in OneDrive or SharePoint and the versions are available.

Can I track changes in an Excel file saved on my computer?
Show Changes and cloud Version History are intended for supported files stored in OneDrive or SharePoint. A local-only file does not gain cloud history just by being saved in Excel; use dated backups or move the working file to an approved cloud location.

Does Show Changes track formatting?
It is primarily for cell values and formulas, not a complete log of formatting and every workbook action. Use Version History to inspect an earlier workbook state when you need to investigate changes outside the cell-edit record.

Is Track Changes the same as Show Changes?
No. Track Changes (Legacy) is tied to the older Shared Workbook workflow. Show Changes is the modern pane for recent edits in supported cloud collaboration. Use the legacy option mainly when you must support an existing legacy workbook process.

Related

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.