Version History Issues

How to Track Every Cell Change and Identify Editors in Excel

Aamir Naveed AkramAamir Naveed Akram Nov 4, 2026 871 views

Question details

The user needs a way to track specific cell edits and identify who made the changes in an Excel workbook.

How to Track Every Cell Change and Identify Editors in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Add Track Changes to the Ribbon

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.

2
Highlight Changes

Navigate to the 'Review' tab and click your newly added 'Track Changes' button, then select 'Highlight Changes'.

3
Configure Tracking Settings

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'.

4
Review Edits

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.

Enable the Legacy Track Changes Feature
Feature Limitations: Legacy Track Changes disables certain Excel features like inserting tables or modifying macros while active.
Track Changes Made Easy

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. 1. Open Your Spreadsheet: Launch WPS Office and open the spreadsheet you want to track changes in.
  2. 2. Access the Review Tab: Navigate to the 'Review' tab located on the top ribbon menu.
  3. 3. Enable Track Changes: Click on 'Track Changes' and select 'Highlight Changes' from the drop-down menu.
  4. 4. Start Logging Edits: Check 'Track changes while editing' to automatically log all future cell modifications and author names.
  5. 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.
Seamlessly track individual cell edits, authors, and timestamps.Highly compatible with Microsoft Excel (.xlsx, .xls) formats.Free and lightweight alternative for robust daily office tasks.
QA img-9

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.