How to Check Edit History in Excel Online (With Simple Steps)

Microsoft Excel has expanded its versatility with the option to check edit history in its excel online platform. It has benefited its users widely as it can help them with checking and editing simultaneously. Let’s look at how to check edit history in excel online with simple steps.


Download Workbook

Find the sample workbook and download it to try yourself.


Step by Step Procedures to Check Edit History in Excel Online

To check edit history in excel online, we have taken a sample dataset of the annual report of 5 students. We will change some data later and check the edit history.

How to Check Edit History in Excel Online.

Just follow the simple steps below:

Step 1: Save Excel Workbook in Onedrive

To start the process, we must save the workbook in Onedrive following the procedure below:

  • In the beginning, turn on the Autosave option in the upper left corner of your workbook. It will keep saving the file in Onedrive automatically.

How to Check Edit History in Excel Online


Step 2: Copy Excel Workbook Link

After saving the file, we will copy the excel workbook link applying the following process:

  • First, click on the Share option in the upper right corner of your workbook.

How to Check Edit History in Excel Online

  • Secondly, a new window will appear with your Microsoft account id. Click on that.

How to Check Edit History in Excel Online

  • Then, another window will appear giving you options to Send link or Copy link.
  • Click on the Copy option in the Copy link section.

How to Check Edit History in Excel Online

  • Finally, you will get the workbook link in a new window. Copy the link.

How to Check Edit History in Excel Online


Step 3: Open Link in Excel Online

Now as we have the workbook link, we can access it like this:

  • Paste the workbook link on the search bar of your browser and press Enter. It will show your workbook on Excel Online platform.

Read More: How to Use Formula to Track Cell Changes in Excel (with Easy Steps)


Step 4: Use Review Tool to Check Edit History

Finally here comes the final stage where we will check the edit history in excel online. For this follow the steps below:

  • At first, click on the Review tab on the upper layer.
  • Select the Show Changes option in the Changes section.

How to Check Edit History in Excel Online

  • After this, you will see a Changes panel has appeared on the right side of your workbook.

  • From this panel, you can see that all my edits for this workbook are showing the necessary information.

Read More: How to Track Changes in Excel (with Easy Steps)


Step 5: Apply Filter to Verify Edit History

You can verify edit history with the Filter option. It is very helpful especially when you are working on a large dataset. Just follow the steps below:

  • First, click on the Filter icon on the Change panel. It will show a drop-down list.
  • From the drop-down list,  select Range.

How to Check Edit History in Excel Online

  • Then, select any cell of your dataset. It will show information like this:

  • Now, click on the arrow button here.

  • Finally, you can check the edit history for that specific cell as well.

  • You can check the edit history of multiple worksheets as well by just following the steps above.

Read More: Excel VBA: Track If a Cell Value Changes


Reason to Check Edit History in Excel Online but Not in Version History

There is another way to check edit history in excel through the version history option in the Microsoft365 app. Let’s see how it works:

  • After you save the workbook in Onedrive, it will look like this:

How to Check Edit History in Excel Online

  • Now, click on the workbook name. It will show a drop-down section.
  • Then, click on Version History.

How to Check Edit History in Excel Online

  • Finally, you can see that it is showing the Version History panel on the right side of your workbook.

The Version History method is not suitable to use because it only shows that you have done some modifications in the workbook. But does not show the details of the edit. This is why it is beneficial to check edit history in excel online for a swift workforce.


Things to Remember

  • Make sure you save original and changed workbooks in Onedrive with separate names in case of lost data.
  • In excel online, you can only see the edit history but can not go back to it. But you can edit further whenever needed.
  • It benefits from multiple user-shared options. So now you can check the edit history of your other authors as well.

Conclusion

Concluding this article, we have learned the process to check edit history in excel online with simple steps. Hope this was a helpful one. Follow ExcelDemy for more updates on Microsoft Excel.


Related Articles

Guria

Guria

Hello! Welcome to my blog. I have completed my Bachelor in Architecture from Ashanullah University of Science & Technology, Dhaka. I am a passionate, goal-oriented person with an immense thirst for knowledge and an attitude to grow continuously. Besides Architectural work, I find it very enthusiastic to work in Excel blogging. Exceldemy is a platform where I have got the opportunity to flourish my skill in Microsoft Excel and therefore, here I will be posting blogs related to it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo