Sometimes you may need to see who made changes in a workbook in Excel. In this article, I’m going to explain how to see who made changes in Excel.
How to See Who Made Changes in Excel: 6 Easy Methods
Here, I will describe six easy methods of how to see who made changes in Excel. For your better understanding, I will be going to use a sample dataset. Which contains three columns. They are Name, Salary, and Designation.
The methods are given below.
1. Applying Version History Feature to See Who Made Changes in Excel
You can apply Version History from the Info to see who made changes in excel.
Steps:
- Firstly, you have to go to the File bar from Ribbon.
- Now, select Info >> choose Version History.
At this time, you will see the following box. Furthermore, you have to upload your file in OneDrive for turning on Version History.
Finally, you can see the Version History. From this, you will be able to know who made changes to your workbook.
2. Employing Version History from Drop-Down Arrow in Excel
In addition, you can employ Version History from the drop-down arrow to see who made changes in Excel.
Steps:
- Firstly, click on the drop-down arrow beside the Saved option.
- Secondly, select Version History.
As a result, you can see the Version History.
Read More: How to Check Edit History in Excel Online
3. Using Track Changes Feature in Offline Version of Excel
You can use the track changes feature to see who made changes in Excel. Here, I will use the same dataset. The steps are given below.
Steps:
- Firstly, go to Review ribbon >> from Track Changes (Legacy) >> select Highlight Changes.
At this time, you will see the following box.
- Now, select Track changes while editing >> from Highlight which changes >> choose All to When >> choose Everyone to Who.
- Then, select Highlight changes on the screen.
- After that, press OK.
Now, If you make any changes to the worksheet then there will be a blue sign on the corner of the cells.
Subsequently, if you click on the blue sign then you can see the details of who made changes.
In addition, in case you have no Track Changes (Legacy) ribbon on your Excel. Then you can follow the following procedure.
Steps:
- Firstly, go to Review.
- Secondly, you have to right-click on any free space on the top menu.
- Thirdly, choose to Customize the Ribbon.
At this time, you can see the following box.
- Firstly, select New Group >> from Rename >> write a name to Display name.
- Secondly, press OK.
- Now, go to Customize Ribbon >> from the drop-down arrow >> choose All Commands.
- Then, from All Commands >> choose to Track Changes (Legacy) >> click on Add.
Subsequently, you have to press OK to see the output.
Finally, you will see the Track Changes (Legacy) ribbon in your Excel.
4. Employing Context Menu Bar While Using Online Version of Excel
You can employ the context menu to see who made changes in Excel. Apart from this, you have to use the online version of Microsoft Excel to implement this method.
You can use the following link to use the live version of Excel.
Steps:
- First, Create an online Excel sheet.
- Then, select the cell that you want to see who made changes to that. Here, I select the D6 cell.
- Now, right-click on cell D6.
- Then, from the Context Menu choose Show Changes.
At this time, you can see who made changes to that cell.
5. Use of Show Changes Feature in Online Version of Excel
You can use the review ribbon to see who made changes in Excel. In addition, you have to use the online version of Microsoft Excel to implement this method.
Steps:
- Firstly, Create an online Excel sheet.
- Secondly, go to Review ribbon >> select Show Changes.
Finally, you can be able to see who made changes to your sheets.
6. Applying Filter Feature from Changes Panel While Using Online Version of Excel
You can use the filter feature for choosing different sheets or ranges to see who made changes. Moreover, you have to use the online version of Excel for this method.
Steps:
- Firstly, from the Review ribbon >> choose to Show Changes.
- Now, from the Changes panel select filter icon >> choose to Sheet >> select Using Filter Feature.
Finally, you can see who made changes to the corresponding Using Filter Feature sheet.
Read More: Excel VBA: Track If a Cell Value Changes
Things to Remember
- Without uploading the file to the drive, you can’t be able to turn on the Version History.
- In the case of the third method, if there is no command Track Changes (Legacy) then you have to customize the ribbon.
- For the 4th, 5th, and 6th methods you have to use the online version of Excel.
Practice Section
Now, you can practice by yourself.
Download Practice Workbook
You can download the practice workbook from here:
Conclusion
I hope you found this article helpful. Here, I have explained 6 methods of how to see who made changes in Excel. Please, drop comments, suggestions, or queries if you have any in the comment section below.
