Show changes made in a workbook

Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac

Use Show Changes in Excel to see who changed a workbook, what they changed, and when they made the change. The Changes pane also shows the previous cell value for reference. Select a worksheet, range, or cell to narrow the list of changes, including bulk edits. You can view changes from the past 365 days. If you have trouble using the feature, see Get help with Show Changes in Excel.

Tip

To explore workbook changes with Copilot in Excel, see Review the change history of your workbook with Copilot in Excel.

View changes for the entire workbook

  1. On the Review tab, select Show Changes.
  2. The Changes pane lists the most recent edits first.
  3. Each entry shows who made the change, where and when they made it, and what they changed.
  4. To view all changes in a bulk edit, select See changes on the bulk card.

Note

Show Changes tracks changes made in Excel for the web, Excel for Windows, Excel for Mac, Excel for iPad, Excel for iPhone, and Excel for Android. You can view changes from the past 365 days.

View changes for a worksheet, range, or cell

  1. Select a worksheet, range, or cell.
  2. Right-click the selection, and then select Show Changes.

Note

If someone edits the workbook while the Changes pane is open, select See New Changes to refresh the list.

Filter changes from the Changes pane

  1. At the top of the pane, select Filter Filter icon. .

  2. Select Range or Sheet to filter the changes shown, and then do the following:

    1. To show changes for a range or cell, select Range, and then enter the range or cell in the text box.
    2. Select the arrow next to the text box to apply the filter.