Version History Issues

How to Search the Show Changes Pane by Author in Excel 365

Bushra ParveenBushra Parveen Nov 11, 2026 868 views

Question details

The user wants to filter the Show Changes pane to view edits made by a specific person.

How to Search the Show Changes Pane by Author in Excel 365
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Show Changes Pane

Navigate to the 'Review' tab on the Excel ribbon and click the 'Show Changes' button.

2
Apply a Filter

Click the filter icon located in the upper right corner of the Show Changes pane.

3
Select the Scope

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.

Utilize Cell, Range, or Sheet Filters as a Workaround
Future Updates: Microsoft frequently updates its Microsoft 365 features. Keep your Office applications updated, as an author-based filter may be added in future releases.
Free Microsoft Office alternative

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. 1. Download and Install: Download WPS Office Free from the official website and run the installer on your computer.
  2. 2. Open Your Workbook: Launch WPS Spreadsheets and open your existing .xlsx files directly without any format conversion.
  3. 3. Manage Data Easily: Enjoy a familiar interface to edit, track, and manage your data efficiently.
Fully compatible with Microsoft Excel (.xlsx, .xls) and CSV formats.Lightweight design ensuring extremely fast loading and smooth performance.Familiar user interface with zero learning curve for seamless migration.Free access to powerful data analysis and formatting tools.
microsoft office alternative - wps office

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.