To enable the classic Track Changes feature in Excel for Microsoft 365 on Windows, go to Review > Track Changes (Legacy) > Highlight Changes, select Track changes while editing. This also shares your workbook, then choose OK. Excel’s newer Show Changes feature works differently: it displays edits in a pane without requiring you to switch on legacy tracking.
What You’ll Need
- Excel for Microsoft 365 on Windows: The steps below focus on the desktop app. Save a separate copy of the workbook before enabling the classic feature, especially if you rely on modern Excel tools.
- Permission to edit the workbook: You may not be able to change tracking settings in a read-only file or one protected by your organization.
- A clear tracking approach: Decide whether you need a shared, highlighted change history (classic Track Changes) or a quick view of recent coauthor edits (Show Changes).
Step-by-Step
- Open the workbook in the Excel desktop app. If the file is open in a browser, use Open in Desktop App first. The classic Track Changes commands are legacy desktop features and may not be available in Excel for the web. If the workbook is important, use File > Save As to create a backup copy before changing its sharing setup.
- Check whether the classic command is visible. Select the Review tab and look for Track Changes (Legacy). If it appears, open its menu and choose Highlight Changes. This opens the settings dialog. The wording may vary slightly by build, but make sure you choose the legacy command rather than assuming that Show Changes turns on the same feature.
- Add the command if you cannot find it. In Excel for Windows, select File > Options > Customize Ribbon. In the Choose commands from list, select All Commands, then find Track Changes (Legacy) or Highlight Changes. Select a suitable tab or create a custom group on the right, choose Add, and select OK. Return to the ribbon and open the command you added. You can also add a legacy command to the Quick Access Toolbar from the same Options area if you prefer.
- Turn on tracking in the Highlight Changes dialog. Select the checkbox labeled Track changes while editing. This also shares your workbook. This is the key setting: opening the dialog alone does not start recording. Excel warns that enabling it shares the workbook using the older shared-workbook feature. Review that consequence before proceeding, then select OK.
- Choose which changes to show, if needed. The dialog may offer filters for When, Who, and Where. Use When to limit the period, Who to focus on a particular editor, or Where to specify a cell range. Leave a filter set to All if you want to include every available change in that category. These options control what Excel highlights or lists; they are not substitutes for checking the main tracking box.
- Choose how Excel presents the changes. Select Highlight changes on screen to mark edits in the worksheet. You may also see List changes on a new sheet, which creates a separate history-style list when you use the dialog to view changes. If you select both, Excel can highlight relevant edits and provide a list. Choose the display that will make review easiest for your team, then select OK.
- Confirm the sharing prompt and save. Excel may ask you to save the workbook or confirm that it will be shared. Follow the prompt, save the file to a location that the intended editors can access, and tell collaborators to use the shared workbook rather than separate downloaded copies. The classic feature is now active. Make a small, reversible test edit in a suitable cell, save, and check whether Excel marks it as a change. Undo the test if appropriate, while remembering that undo behavior can be limited in a shared workbook.
- Review or stop classic tracking when finished. To change the display filters or turn tracking off, return to Review > Track Changes (Legacy) > Highlight Changes. Clear Track changes while editing to stop recording new edits, then confirm and save. Turning it off does not necessarily remove old change records. If you need to decide which recorded edits to keep, look for the separate legacy Accept/Reject Changes command; review changes carefully before accepting or rejecting them.
- Use Show Changes for current coauthoring instead, when appropriate. For a workbook shared through OneDrive or SharePoint, select Review > Show Changes to open the changes pane. You can inspect who changed a cell, when it changed, and the prior value when that information is available. This does not require enabling the classic shared-workbook setting. It is often the better choice for recent collaborative edits, but it is not a permanent, full audit log and its history is limited.
Common Mistakes
- Confusing Show Changes with classic Track Changes. Show Changes is a pane for reviewing recent edits in supported collaborative workbooks. It does not activate the older highlighted-change system. Choose the feature that fits your goal before relying on a history.
- Opening the dialog but not checking the main box. Choosing a time, editor, or range filter does not itself enable tracking. Confirm that Track changes while editing is selected, and complete any save or sharing prompt.
- Assuming the classic feature is a complete audit trail. It is a legacy collaboration feature with limitations, not a guaranteed record of every kind of workbook activity. Do not treat it as a compliance log or assume it captures every formatting change, structural change, or action.
- Sharing the workbook without telling collaborators. The classic option uses an older shared-workbook model, which can change how the file is edited and limit some Excel features. Agree on where the working copy lives and avoid having people edit separate copies that are later combined.
- Turning tracking off before reviewing the history. If you need to settle disputed edits, review and save the relevant information first. Do not assume that switching off tracking preserves every detail indefinitely or that turning it back on will restore missing history.
Tips
- Choose a method based on the task. For a team editing a cloud workbook and checking recent cell edits, start with Review > Show Changes. For a workflow that specifically needs the older shared-workbook behavior and highlighted edits, use Track Changes (Legacy) after checking its limitations.
- Agree on a review routine. Tell collaborators what counts as a meaningful edit, when they should save, and who is responsible for reviewing or accepting changes. A clear routine is more useful than turning on a feature that nobody checks.
- Keep a clean baseline. Save a named copy before enabling legacy tracking, and consider keeping a dated copy before a major review round. A baseline makes it easier to compare the workbook if sharing settings or change history become confusing.
- Use filters carefully. A narrow date, editor, or cell-range filter can make a long list manageable, but it can also hide relevant edits from the current view. Return filters to All when you need to inspect the full available set.
- Do not rely on colored cells alone. Highlighting is a visual aid, not necessarily a complete explanation of who changed what. Open the relevant changes list or pane and inspect the cell’s values before making a decision.
Troubleshooting
The Track Changes (Legacy) command is missing. First confirm that you are using the Windows desktop app, not Excel for the web. Then add the command through File > Options > Customize Ribbon by selecting All Commands. If your organization manages Office settings, an administrator may restrict available commands. If the command still is not available, use Review > Show Changes for supported coauthoring, or ask your administrator about the workbook’s environment.
The checkbox is unavailable or Excel will not enable the feature. Check whether the workbook is protected, opened read-only, or stored in a location where you lack editing rights. Also consider whether it uses features incompatible with the older shared-workbook mode. Save a backup, remove protection only if you are authorized and know the password, and try again in the desktop app. If the workbook depends on modern features, do not force the legacy mode; use Show Changes or another version-comparison workflow instead.
Edits are not appearing as expected. Verify that the tracking checkbox remains selected, that you saved the workbook, and that the When, Who, and Where filters are not excluding the edit. Check that you and your collaborators are editing the same shared file. A change made in a downloaded duplicate will not necessarily appear in the original workbook’s history.
Show Changes is empty or missing edits. Confirm the workbook is saved in a supported OneDrive or SharePoint location and that you opened the same cloud file as your collaborators. The pane is designed for recent changes, not a complete long-term record; some actions or changes may not be shown, and older entries can fall outside its available history. Check the workbook’s version history for earlier saved versions, or ask the editor to identify the affected cell and time.
The workbook behaves differently after enabling legacy tracking. This is possible because the classic feature shares the workbook using older collaboration settings. Some modern functionality may be unavailable or behave differently. If that trade-off is not acceptable, preserve a backup and use a cloud collaboration workflow with Show Changes instead. Avoid converting or changing sharing settings until you understand how the workbook is used by everyone who edits it.
Frequently Asked Questions
Is Track Changes still available in Excel for Microsoft 365?
Yes, the classic feature may be available as Track Changes (Legacy), but it is not always shown on the ribbon by default. You may need to add it through Excel Options. Microsoft 365 also offers Show Changes, a separate, newer review tool.
Does Show Changes need to be turned on first?
No. For a supported cloud workbook, open Review > Show Changes to view available recent edits. It is not a switch that begins the classic tracking process, and it should not be treated as a permanent audit log.
Can I enable classic Track Changes in Excel for the web?
The legacy tracking controls are desktop features and may not be available in the browser. Open the workbook in Excel for Windows to look for Track Changes (Legacy). In the web app, use Show Changes if it is available for the workbook.
Does enabling Track Changes automatically share the workbook?
The classic setting explicitly says that tracking also shares the workbook. That older sharing model can affect compatibility and editing features. Read Excel’s prompt, save a backup, and make sure the sharing arrangement suits the people who need to edit the file.
How do I accept or reject edits?
For the classic system, use the separate Accept/Reject Changes legacy command if it is available, then review each proposed change before choosing. Show Changes is primarily for inspecting recent edits; it does not use the same classic accept-or-reject workflow.
Can I use Track Changes on Excel for Mac?
Ribbon placement and command availability can differ by Mac version. Look under Review for legacy tracking commands; if they are not available, use Show Changes for a supported collaborative workbook. On Mac, common shortcuts also differ from Windows—for example, undo is Command+Z rather than Ctrl+Z.
Related
- How to Delete an Excel Workbook Safely
- How to Delete Strikethrough in Excel in a Few Steps
- Excel Calendar With Correct Dates: A Step-by-Step Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Group Rows in Excel and Hide ThemTo group rows in Excel and hide them, select the detail rows, choose Data > Outline > Group,…
- Split a Cell in Excel: Separate Text or Unmerge CellsExcel cannot divide one worksheet cell into two independent cells; to separate its contents, use Data > Text…
- Duplicate Filter in Google Sheets: Find Repeated RowsTo filter duplicates in Google Sheets, add a helper column with a COUNTIF formula, then filter that column…
- Consolidate CSV Files in One Excel WorkbookYes. In Excel for Microsoft 365 on Windows, use Power Query to combine multiple CSV files into one…
- Outlook Closing Signature: How to Create OneTo create a closing signature in Outlook, open the signature settings for your version, write your sign-off and…
- How to Create a Background Template in WordTo create a reusable background template in Microsoft Word, place a picture or colored shape in the document…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.