Show Changes in Excel lets you see exactly what edits were made to your workbooks, so you can confidently allow others to collaborate on your work. You can see details of who changed what, where, and when, along with the previous value of the cell for quick reversion. You can narrow down the list of changes by selecting any sheet, range, or individual cell, to see all changes that were made, including bulk edits. You can see past changes for up to 60 days. If you're having trouble, Get help on showing changes.
View changes for the entire workbook
-
In the Review tab, select Show Changes.
-
Changes are shown in the pane with the most recent changes on top, in the order the changes were made.
-
You can see who made edits, exactly where in the workbook, when, and what they changed.
-
You can also see Changes made at once by clicking on See changes in a bulk card.
Note: Show Changes tracks changes made from Windows Desktop, Excel on the Mac, iPad, iOS and Android phones. You can see past changes for up to 60 days.
Filter and see changes for a subset or range
1. Select any sheet, range or single cell.
2. Right click to open the context menu and select Show Changes.
Note: If you or others edit the workbook while this pane is open, select the See New Changes button to update the changes. The notification lets you stay in control when you want to refresh the list and not be distracted when reviewing changes.
Filter changes from the Changes pane
-
At the top of the pane, select the Filter icon.
-
Select Range or Sheet to filter the changes shown, and then do the following:
-
To show a range or cell’s changes, select Range and enter the range or cell in the text box.
-
Select the arrow icon next to the text box to confirm.
-