How to See Who Made Changes in Excel (6 Easy Methods)

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.


Download Practice Workbook

You can download the practice workbook from here:


6 Easy Methods to See Who Made Changes in Excel

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.

How to See Who Made Changes

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.

How to See Who Made Changes

At this time, you will see the following box. Furthermore, you have to upload your file in OneDrive for turning on Version History.

 How to See Who Made Changes

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.

 How to See Who Made Changes


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.

How to See Who Made Changes

  • 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.

How to See Who Made Changes

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.

How to See Who Made Changes

At this time, you can see the following box.

 How to See Who Made Changes

  • 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.

 How to See Who Made Changes

  • Then, from All Commands >> choose to Track Changes (Legacy) >> click on Add.

Subsequently, you have to press OK to see the output.

 How to See Who Made Changes

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.

 How to See Who Made Changes

  • 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.

 How to See Who Made Changes


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.

 How to See Who Made 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.

 How to See Who Made Changes

Finally, you can see who made changes to the corresponding Using Filter Feature sheet.


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.

 How to See Who Made Changes


Conclusion

I hope you found this article helpful. Here, I have explained 6 methods of how to see who made changes in Excel. You can visit our website Exceldemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.

Musiha
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo