How to Track Every Cell Change and Identify Editors in Excel
Question details
The user needs a way to track specific cell edits and identify who made the changes in an Excel workbook.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Collaborating on an Excel workbook and needing precise audit trails for cell modifications and editor identities.
- Observed behavior
- Standard version history lacks individual cell-level edit tracking, and Excel does not offer a prominent Word-style track changes feature by default.
Ensure your workbook is saved locally or on a supported network drive, as some legacy tracking features and VBA macros may behave differently when co-authoring online.
Enable the Legacy Track Changes Feature
Use Excel's built-in legacy tracking feature to monitor edits, though it must first be added to the ribbon in modern Excel versions.
Microsoft has hidden the traditional Track Changes feature in newer versions of Excel in favor of cloud-based co-authoring. However, you can still restore and use it for detailed cell-level tracking.
Click on 'File' > 'Options' > 'Customize Ribbon'. In the 'Choose commands from' dropdown, select 'All Commands'. Find 'Track Changes (Legacy)' and add it to a custom group under the Review tab.
Navigate to the 'Review' tab and click your newly added 'Track Changes' button, then select 'Highlight Changes'.
Check the box for 'Track changes while editing. This also shares your workbook'. Set the 'When', 'Who', and 'Where' parameters to specify what to track, then click 'OK'.
Edited cells will now display a small triangle in the corner. Hover over the cell to see a tooltip detailing the editor, timestamp, previous value, and new value.

Create a Custom VBA Audit Trail
Use a VBA macro to record precise details like date, user, cell address, and previous/new values on a hidden worksheet.
Compare Worksheets Using Formulas
If you cannot track changes live, compare an older version of the worksheet with the current one using formulas.
Track Spreadsheet Changes Effectively with WPS Office
WPS Spreadsheet provides intuitive, built-in review tools to easily track, accept, or reject cell changes, making collaboration and auditing straightforward without complex ribbon customizations.
- 1. Open Your Spreadsheet: Launch WPS Office and open the spreadsheet you want to track changes in.
- 2. Access the Review Tab: Navigate to the 'Review' tab located on the top ribbon menu.
- 3. Enable Track Changes: Click on 'Track Changes' and select 'Highlight Changes' from the drop-down menu.
- 4. Start Logging Edits: Check 'Track changes while editing' to automatically log all future cell modifications and author names.
- 5. View Editor Details: Hover your cursor over any highlighted cell to view a detailed popup showing the editor's name, the date, and the exact data change.

Frequently Asked Questions
Why can't I find the Track Changes button in modern Excel?
Microsoft removed the Track Changes button from the default ribbon in newer versions of Excel, replacing it with the 'Show Changes' feature tied to OneDrive co-authoring. You can restore the old feature via File > Options > Customize Ribbon.
Does Excel for the Web support tracking individual cell changes?
Excel for the Web provides a basic 'Show Changes' pane, but it does not support the full legacy cell-change tracking interface. For detailed auditing or VBA-based tracking, you must open the file in the desktop application.
Can I prevent users from deleting the VBA audit trail?
Yes. You can protect the audit sheet by setting its visibility to 'xlSheetVeryHidden' in the VBA editor, and then lock the VBA project and the workbook structure with passwords so other editors cannot bypass the tracking.




