Microsoft Excel logo on a green background

Launch the "Show Changes" tool from the Review tab on the ribbon to view a list of changes along with the user that made them. You can also filter these changes to look for only specific changes.

Do you see something unusual in your Excel spreadsheet? Wondering how the change may have happened? Whether you’re working with others or alone on an Excel sheet, there’s a simple way to see the changes that take place.

With the click of a button, you can view the changes in a workbook for each sheet. You can see who made the edit, when they made it, and exactly what changed.

This feature was first made available in Excel for the web but was later added to the Excel desktop application on Windows and Mac for Microsoft 365 subscribers.

What Changes Can You See?

With the Show Changes feature, you can see edits to cell values and formulas for up to 60 days. This includes changes involving moving, sorting, inserting, and deleting. However, you can’t see changes to charts, shapes, objects, pivot table operations, formatting, hidden cells, filtering, or deleted locations.

How to Show Changes in Excel

Open your Excel workbook, go to the Review tab, and select “Show Changes” in the Changes section of the ribbon.

Show Changes on the Review tab in Excel

You’ll see a panel open on the right side with a list of changes for the workbook. You’ll see the person who made the change with the date and time.

You can then review the sheet, item, and cell that was edited.

Show Changes panel in Excel

To see the change in the sheet, select the cell reference, sheet name, or edit icon (pencil) in the box for the change in the sidebar. You’ll then see the changed item highlighted in the sheet.

Highlighted cell that was changed

Use a Filter to Show Changes

By default, you’ll see all the changes to a workbook when you click the Show Changes button. But you can also filter the list to view a specific sheet or range of cells.

RELATED: How to View and Restore Previous Versions of Excel Workbooks

With the Show Changes sidebar open, select the filter drop-down arrow at the top. You can move your cursor to Sheet and then pick a particular spreadsheet in the pop-out menu to view only those changes.

Filter by sheet for Show Changes

You can also choose “Range” to see changes to certain cells.

Enter the cell range (with the sheet name) in the box to the right or select the cells on the sheet to populate the Range box. Then, click the green arrow to view those changes.

Filter by range for Show Changes

When you finish using the filters, select “Clear Filter” in the drop-down menu. The panel then shows the entire list of changes again.

Clear Filter in the Show Changes Filter menu

Seeing the changes you or your collaborators make in Excel is easier than ever. Be sure to keep this guide bookmarked for future use.

Profile Photo for Sandy Writtenhouse Sandy Writtenhouse
With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage.
Read Full Bio »