How to Track Which User Edited Cells in Excel with WPS Office
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.

- 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.
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.
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.
Open the affected Excel workbook in WPS Office Spreadsheets, click the Review tab on the ribbon, and make sure the file is editable.
In the Review tab, click Track Changes > Highlight Changes, enable Track changes while editing, and choose When: All or Since date as needed.
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.
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.

Compare Saved Versions with WPS Version History
Use this when Track Changes was not enabled and you need to review saved workbook snapshots to find which user saved a modified version.
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. Open the Excel workbook: Launch WPS Office Spreadsheets and open the .xlsx file you need to audit.
- 2. Open Review > Track Changes: Click the Review tab, then click Track Changes > Highlight Changes and enable Track changes while editing.
- 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. 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. 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.

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.




