Version History Issues

How to Track Which User Edited Cells in Excel with WPS Office

Anum MushtaqAnum Mushtaq Nov 13, 2026 869 views

Question details

The user wants to identify edits made by a specific user in a shared Excel workbook and count affected cells inside a selected range.

How to Track Which User Edited Cells in Excel with WPS Office
Product
WPS Office Spreadsheets
Device & OS
not provided
Scenario
A shared workbook is edited by multiple users, and the reviewer needs to know which cells were changed by a particular person.
Observed behavior
Excel and WPS Spreadsheets do not provide a standard worksheet formula that counts cells edited by a specific user; a review or tracking method is required.
Before you start

Confirm that the workbook is saved as an .xlsx or WPS-supported shared workbook and that all reviewers have edit access. If you need an audit trail for future edits, enable tracking before changes are made.

Solution 1Recommended

Use Track Changes in WPS Spreadsheets to Identify Who Edited Each Cell

Best for inspecting a shared workbook and highlighting every cell change with editor, time, and cell reference.

WPS Spreadsheets includes a Track Changes feature that records edits in shared workbooks. It does not provide a worksheet formula to count edits by user, but the change list lets you see which cells a specific user changed and then count or select them manually.

1
Open the workbook and open the Review tab

Open the affected Excel workbook in WPS Office Spreadsheets, click the Review tab on the ribbon, and make sure the file is editable.

2
Turn on Track Changes

In the Review tab, click Track Changes > Highlight Changes, enable Track changes while editing, and choose When: All or Since date as needed.

3
Open the change list

Click Track Changes > View Changes or Accept/Reject Changes to display the change history, then read the User column to see who edited each cell.

4
Inspect the target range

Select the range you want to audit and count the highlighted cells associated with the specific user, or use Find & Select > Go To Special for visible cell attributes.

Use Track Changes in WPS Spreadsheets to Identify Who Edited Each Cell
No formula counts edits by user: Both Excel and WPS Spreadsheets lack a standard worksheet formula that returns the number of cells edited by a particular user. Use the change list or a controlled logging solution for automated per-user counts.
WPS Office Spreadsheets

Track Excel Cell Edits with WPS Office Spreadsheets

Open the Excel workbook in WPS Office Spreadsheets and use Track Changes to highlight edits, view the user, time, and cell reference, and manually count affected cells in the selected range.

  1. 1. Open the Excel workbook: Launch WPS Office Spreadsheets and open the .xlsx file you need to audit.
  2. 2. Open Review > Track Changes: Click the Review tab, then click Track Changes > Highlight Changes and enable Track changes while editing.
  3. 3. Review the change list by user: Click Track Changes > View Changes to see the User, Date, and Cell Reference columns for each edit.
  4. 4. Select the range and count affected cells: Highlight the target range and count the cells listed for the specific user in the change history.
  5. 5. Save the workbook as .xlsx: Save the file in Excel-compatible .xlsx format so other Excel and WPS users can continue reviewing the tracked changes.
Built-in Track Changes shows editor, time, and cell reference without extra add-insOpens and saves .xlsx Excel workbooks with full Microsoft Office format compatibilityFree, lightweight Office suite with a familiar Review ribbonWPS Cloud version history provides saved snapshots for additional auditing
microsoft office alternative - wps office

Frequently Asked Questions

Can I use a formula to count how many cells a specific user edited in Excel?

No standard worksheet formula returns that count in either Excel or WPS Spreadsheets. Use Track Changes or Show Changes to view the editor for each cell, then count manually or use a VBA/Office Scripts logging solution.

Does WPS Spreadsheets support Microsoft Excel's Show Changes feature?

WPS Spreadsheets has its own Track Changes feature under the Review tab that records who changed a cell, when, and what changed. For Microsoft 365-specific Show Changes, open the file in Microsoft 365 Excel or Excel for the web.

How do I enable Track Changes in WPS Spreadsheets?

Open the workbook, click Review > Track Changes > Highlight Changes, enable Track changes while editing, and choose the scope before users start editing.

Can I track edits after they were already made if Track Changes was not enabled?

If Track Changes was off, WPS cannot retroactively name the editor for past cell changes. Check WPS Cloud Version History or backup versions to compare saved snapshots, but user-level cell attribution may be missing.

Will WPS Track Changes work with .xlsx files?

Yes. WPS Spreadsheets opens and saves .xlsx workbooks, and its Track Changes feature works with Excel-compatible shared workbooks.