How to Search the Show Changes Pane by Author in Excel 365
Question details
The user wants to filter the Show Changes pane to view edits made by a specific person.

- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- Reviewing document version history and attempting to track specific collaborators' edits within a shared workbook.
- Observed behavior
- Excel 365 provides filters for cells, ranges, and sheets in the Show Changes pane, but it lacks a built-in search function to filter changes directly by author.
Ensure your Excel workbook is saved to OneDrive or SharePoint, as the Show Changes feature relies on cloud storage to track and record version history.
Utilize Cell, Range, or Sheet Filters as a Workaround
While you cannot filter by author directly, you can narrow down changes to specific areas of the workbook where you know the collaborator was working.
Microsoft 365 does not currently support filtering the Show Changes pane by user name. However, filtering by location can help you isolate edits made in sections assigned to specific team members.
Navigate to the 'Review' tab on the Excel ribbon and click the 'Show Changes' button.
Click the filter icon located in the upper right corner of the Show Changes pane.
Choose to filter by 'Sheet' or 'Range'. If selecting Range, highlight the specific cells you want to investigate to see the edit history for that exact area.

Review Overall Version History
If you need to identify who made changes at a specific time, browsing previous versions of the workbook can provide clarity.
Try WPS Office for Seamless Spreadsheet Management
If Excel 365's collaboration limitations are slowing down your workflow, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet tool with robust features at no cost.
- 1. Download and Install: Download WPS Office Free from the official website and run the installer on your computer.
- 2. Open Your Workbook: Launch WPS Spreadsheets and open your existing .xlsx files directly without any format conversion.
- 3. Manage Data Easily: Enjoy a familiar interface to edit, track, and manage your data efficiently.

Frequently Asked Questions
Can I filter track changes by a specific user in older versions of Excel?
Yes, in older desktop versions of Excel that use the legacy 'Track Changes' feature (via Shared Workbooks), you could filter changes by 'Who'. However, this legacy feature has been replaced by modern co-authoring and the 'Show Changes' pane in Microsoft 365, which currently lacks user-specific filtering.
How long are changes kept in the Show Changes pane?
By default, Excel 365 retains the edit history in the Show Changes pane for up to 60 days. If you need to review edits made further back in time, you will need to rely on the file's overall Version History.
Why is the Show Changes button grayed out in Excel 365?
The Show Changes feature is exclusively available for workbooks saved in Microsoft's cloud storage (OneDrive or SharePoint). If your file is saved locally on your computer's hard drive, the button will be disabled. Save or upload the file to the cloud to enable change tracking.




