What Track Changes Does and When You Need It

Track Changes is an Excel feature that records every edit made to a spreadsheet — who changed what, when they changed it, and what the old value was. When you turn it on, Excel marks insertions, deletions, and cell edits with colored borders and comment boxes. You can then review each change one at a time and accept or reject it before finalizing the document.

This matters most when multiple people work on the same file, or when you need a record of who modified financial data, project timelines, or other information that matters later. It also protects you if someone changes a number and you need to know what it was before. Track Changes is not the same as version history — it shows you the specific edits, not just different saved versions of the whole file.

Key Takeaways

  • Turn on Track Changes in the Review tab, then share the file — Excel records all edits made while the feature is active.
  • Changed cells show colored borders and small triangles in the corner; hover over them or open the comment to see who changed it and when.
  • You review changes one by one in the Accept/Reject dialog, which shows the old value and new value side by side.
  • Once you accept all changes, Track Changes turns off automatically and the file becomes a normal spreadsheet.
  • Track Changes works in Excel on Windows and Mac, but not in Excel Online or Google Sheets.

How to Turn On Track Changes

Open the spreadsheet you want to share. Click the Review tab at the top of the ribbon. In the Changes group, click Track Changes, then select Highlight Changes from the dropdown menu.

A dialog box appears with three checkboxes. Check the box next to Track changes while editing. The other two boxes — "When" and "Who" — let you filter which changes show up later, but you can leave them unchecked for now. Click OK. Excel will ask you to save the file; click Save. The file is now in Track Changes mode.

From this point forward, every cell edit, row insertion, column deletion, and format change made by anyone who opens this file will be recorded. The file is still a normal .xlsx file — you can email it, upload it to a shared folder, or send it through any other method. Each person who edits it needs to have Track Changes turned on in their copy, or their edits won't be tracked.

How to See Who Changed What

When someone edits a tracked spreadsheet, the changed cell gets a colored border — usually blue, red, or purple depending on who made the change. A small triangle appears in the top-left corner of the cell. Hover your mouse over that triangle and a comment box pops up showing the editor's name, the date and time, and what was changed.

If you want to see all changes at once instead of hovering, go back to the Review tab and click Track Changes, then Highlight Changes again. A dialog appears with a list of all edits. You can filter by date range, by person, or by cell range — for example, to see only changes made by Sarah in the last week, or only changes in column B. Click OK and Excel highlights only the changes that match your filter.

The comment boxes stay visible until you accept or reject the change. If the spreadsheet gets crowded with colored borders, you can turn off the visual highlighting temporarily by unchecking Track changes while editing in the Highlight Changes dialog — but this stops recording new edits, so only do this when you are done collecting input.

How to Accept or Reject Individual Changes

Once all edits are in, you review them one by one. Go to the Review tab and click Track Changes, then select Accept/Reject Changes. Excel opens a dialog that shows the first change: the cell address, the old value, the new value, who made it, and when.

You have four options for each change. Click Accept to keep the new value and move to the next change. Click Reject to restore the old value and move on. Click Accept All to approve every remaining change at once — use this only if you trust all the edits. Click Reject All to undo every remaining change — use this only if you know the edits are wrong.

Most of the time you will go through one by one. If a change looks wrong, reject it and the cell goes back to what it was before. If it looks right, accept it. The dialog moves to the next change automatically. When you reach the end, Excel asks if you want to continue from the beginning; click No. Track Changes turns off, the colored borders disappear, and the file becomes a normal spreadsheet with all accepted changes locked in.

What Happens If You Reject a Change

When you reject a change, Excel restores the cell to its previous value — the value before the edit you are rejecting. If a cell was edited three times and you reject the second edit, the cell goes back to what it was after the first edit, and the third edit is still pending. You then review the third edit separately and decide whether to accept or reject that one too.

Rejecting a change does not delete the record of it. The change stays in the history until you finish reviewing all changes. If you reject a change by mistake, you can click Undo when ready to put it back in pending status and review it again. Once you close the Accept/Reject dialog, you cannot undo rejections — the file is finalized.

Track Changes Limitations and Workarounds

Track Changes does not work in Excel Online or in Google Sheets. If your team uses Excel Online, you will need to read the file to your computer, turn on Track Changes, make edits, upload it back, and have others do the same. This is clumsy but necessary — Excel Online straightforward does not have the feature.

Track Changes also does not record changes to charts, pivot tables, or macros — only cell values and formatting. If your spreadsheet relies heavily on those elements, Track Changes will miss important edits. In that case, consider using version history instead: save the file to OneDrive or SharePoint, and Excel will keep timestamped snapshots of each save automatically.

If you share a tracked file and someone opens it without Track Changes turned on, their edits will not be recorded. Make sure everyone on your team knows to turn on Track Changes before they start editing. You can also protect the file with a password so that Track Changes cannot be turned off — go to Review, click Protect Sheet, and set a password. Anyone who edits the file will have to keep Track Changes on.

When to Use Track Changes Instead of Other Methods

Track Changes works best for small teams reviewing a single file over a short period — a budget spreadsheet circulating for approval, a project timeline being updated by three people, or a data entry form being checked for errors. It gives you a clear record of who changed what and lets you undo specific edits without losing the whole file.

If your team is large, the file is complex, or edits happen over weeks or months, consider alternatives. OneDrive or SharePoint version history is simpler — you do not have to remember to turn anything on, and you can see all versions of the file at any point in time. Google Sheets has a built-in version history and a "Suggesting" mode that works like Track Changes without the setup. If you need to track changes to many files or enforce approval workflows, a document management system or project management tool may be a better fit than Excel alone.

Frequently Asked Questions

Can I turn off Track Changes and turn it back on later?

Yes. Unchecking Track changes while editing stops recording new edits, but it does not erase the changes already recorded. You can turn it back on anytime and continue tracking. However, any edits made while it was off will not be recorded. Once you accept or reject all changes, Track Changes turns off permanently for that file.

What if two people edit the same cell?

Excel records both edits as separate changes. When you review them, you see the first edit, then the second edit. You accept or reject each one independently. If you reject the second edit, the cell reverts to the value after the first edit. If you accept both, the second edit wins and becomes the final value.

Can I see Track Changes on a file someone else sent me?

Yes. Open the file and go to Review, then Track Changes, then Highlight Changes. The dialog shows all recorded edits with colored borders and comment boxes. You can filter by person or date, and you can accept or reject changes. The file must have been saved with Track Changes on — if Track Changes was turned off before the file was sent to you, those edits are not recorded.

Does Track Changes slow down Excel?

Slightly, especially on very large files with thousands of edits. If you notice Excel running slowly, you can turn off the visual highlighting (uncheck Highlight changes on screen in the Highlight Changes dialog) while keeping Track Changes recording. The edits are still tracked; you just do not see the colored borders until you turn highlighting back on.

What if I want to keep the file but stop tracking changes?

Accept or reject all pending changes first. Then go to Review, click Track Changes, and select Highlight Changes. Uncheck Track changes while editing and click OK. The file is now a normal spreadsheet with no tracking active. All accepted changes are permanent; all rejected changes are gone.