Quick Links
Summary
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 may 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’reworking with othersor 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.
What Changes Can You See?
With theShow Changes feature, you may 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.
You’ll see a panel open on the right side with a list ofchanges for the workbook. You’ll see the person who made the change with the date and time.
you’re able to then review the sheet, item, and cell that was edited.
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.
Use a Filter to Show Changes
By default, you’ll see all thechanges to a workbookwhen 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 may move your cursor to Sheet and then pick a particular spreadsheet in the pop-out menu to view only those changes.
you may 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.
When you finishusing the filters, select “Clear Filter” in the drop-down menu. The panel then shows the entire list of changes again.
Seeing the changes you or your collaborators make in Excel is easier than ever. Be sure to keep this guide bookmarked for future use.
