Before you ask your teammates to review your Excel worksheets, turn on Excel revision tracking for your shared workbook. When you use the track changes feature in Excel, you can see who made changes to the worksheet or workbook and what changes they made. After your team has completed the review, compare your original data with the reviewers' changed data. Then accept or reject their changes and turn off Track Changes to finalize the document.
How to Use 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 simple and quick way to review a document. If you want more information about the revisions made, or if your team members are using older versions of Excel, use the legacy Track Changes feature.
You won't find the Track Changes option on the Excel ribbon in Excel for Microsoft 365 and Excel 2019. You'll only see the Track Changes commands on the Review tab in Excel 2016 and earlier 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 on the Review tab.
To enable the old Track Changes feature in Windows, follow these steps:
