title: “How To Use Track Changes In Excel” ShowToc: true date: “2023-01-09” author: “Robert Vahle”
Can You Track Changes in Excel?
When you want your team to review and edit your Excel workbook, you have two options. If everyone on your team uses Excel for Microsoft 365, the co-authoring feature is a straightforward and quick way to review a document. If you want more information about the revisions made or if your team members work with older versions of Excel, use the legacy Track Changes feature.
You won’t find the option to track changes in Excel for Microsoft 365 and Excel 2019 on the Excel Ribbon. You’ll only see the track changes commands in the Review tab of Excel 2016 and older versions. The option is available in newer versions of Excel, but you’ll need to add the associated track changes commands to a new group in the Review tab.
Enable Track Changes in Newer Versions of Excel
To enable the legacy Track Changes feature in Windows:
Go to the File tab and select Options. In the Excel Options dialog box, select Customize Ribbon. Select the Choose command from drop-down arrow and choose All commands. Select the Customize the Ribbon drop-down arrow and choose Main Tabs. Expand and highlight the Review category. Select New Group. Make sure the New Group entry is highlighted, then select Rename. In the Rename dialog box, enter a display name for the group. For example, enter Track Changes. Select OK to apply the change and close the Rename dialog box. In the Excel Options dialog box, go to the All Commands list, then choose each of the following: Compare and Merge Workbooks (Legacy)Protect Sharing (Legacy)Share Workbook (Legacy)Track Changes (Legacy) After you select each command, select Add to add that command to the Review tab. Select OK to apply your changes and close the Excel Options dialog box. The four track changes commands appear on the Review tab in the new group that you created.
How to Turn On Track Changes in Excel
After you’ve entered all the information in the worksheet, turn on the Track Changes feature before making the Excel workbook available for review.
Compare and Merge Workbooks (Legacy)Protect Sharing (Legacy)Share Workbook (Legacy)Track Changes (Legacy)
After you select each command, select Add to add that command to the Review tab.
Go to the Review tab and select Track Changes > Highlight Changes. In the Highlight Changes dialog box, select the Track changes while editing check box. Select the When check box and set it to All. Select the Who check box and set it to Everyone. Select the Highlight changes on screen check box. Select OK. On the Review tab, select Share Workbook. In the Share Workbook dialog box, go to the Editing tab and select the Use the old shared workbooks feature instead of the new co-authoring experience check box. Select OK. On the Review tab, select Protect Shared Workbook. In the Protect Shared Workbook dialog box, select the Sharing with track changes check box. Select OK.
Share the Workbook
When your shared workbook is ready to be reviewed, upload the file to a location that your team members can access. For example, upload the workbook to a SharePoint site, a OneDrive folder, or Dropbox.
After the workbook is uploaded, inform your team members that the file is ready for their review. One way to do this is to use the Share feature in Excel.
How to View and Accept Changes
After all your reviewers have had a chance to review and edit the workbook, it’s time to accept or reject those changes.
Go to the Review tab and select Track Changes > Accept or Reject Changes. In the Select Changes to Accept or Reject dialog box, clear the Where checkbox to accept or reject changes to the entire workbook. Select OK. For each change, select either Accept or Reject.
How to Turn Off Track Changes
When you’re finished with the review and don’t want to continue to track changes made to the workbook, turn off the Track Changes feature.
Go to the Review tab and select Track Changes > Highlight Changes. In the Highlight Changes dialog box, clear all the check boxes. Select OK.
