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

Get FREE Advanced Excel Exercises with Solutions!

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.

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

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.

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

Read More: Excel VBA: Track If a Cell Value 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


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.


Related Articles


<< Go Back to Track Changes | Share Workbook | Workbook in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Musiha Mahfuza Mukta
Musiha Mahfuza Mukta

Musiha Mahfuza Mukta is a marine engineer who loves exploring Excel and VBA programming. To her, programming is a time-saving tool for dealing with data, files, and the internet. She's skilled in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. With a B.Sc in Naval Architecture & Marine Engineering from BUET, she's shifted gears and now works as a content developer. In this role, she creates techy content exclusively focused on Excel... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo