How to Review Version History in Microsoft Excel Online – Guide
Microsoft Office offers the ability to track changes made to a document and automatically save them as versions. This version history allows you to go back in time and restore a previous version of a document created with Word, Excel or PowerPoint using the Windows 10 or web version of the application. In addition, the version history also allows you to view and compare the different versions. versions to better understand the progress of the document.
Although this is a helpful feature to work without having to worry about the changes you or anyone else makes to a document, this feature is limited to files you store on OneDrive, OneDrive for Business, and SharePoint, and depending on the platform, the steps for using version history vary. If you’ve ever opened a spreadsheet only to realize you made a mistake and saved the file, you know how irritating that can be. Microsoft Excel for the web lets you view your version history and restore or download a previous version. ..
Review the version history of a document file in Microsoft Excel Online
You can review previous versions of a document file in Microsoft Excel Online easily. Just click on File > Info and select “Previous Versions”.
When you open a file for editing, the latest version will be at the top of the list. You can see who made the corresponding edit and when it was saved. This is useful if you are collaborating on a team and want to know who made which adjustments. ..
Open the Excel Online version of the table.
If you want to “restore” an old version of the Excel file you have opened, simply click “Restore” below the version name in the list. The entire web page will refresh and you will see the version you just selected on the screen. You can now continue working on the spreadsheet as you normally would. ..
If you want to go back in time in a Firefox document, you can download a specific version of the file and save it on your computer. Then, you can open the file in Microsoft Excel and see the different versions.
When reviewing a file’s version history, you will be in Preview or Preview Only mode. Therefore, you cannot make any changes to the file. This view is for viewing previous versions only. To close the version history without restoring or downloading a previous version, simply close the tab or use the Application Launcher in the upper left corner to return to the Excel Online screen and reopen the workbook.
Final note
This guide will show you how to review version history in Microsoft Excel Online. First, we will create a new worksheet and name it “VersionHistory”. Then, we will add the following data to it: Name: VersionHistory Data: Version 1.0.0.0 Version 2.0.2.0 Version 3.1.5.1 Version 4.1.3.2 Version 5.2.6.0 Now that we have our VersionHistory worksheet, let’s start reviewing it! To review a specific version of a document, we can use the Review button on the ribbon at the top of the sheet (or by pressing F5). This will open up the Review dialog box shown below: In this dialog box, we can see all of the versions of our document that have been created so far (including those that have yet to be created). We can also see which versions are currently being used by our document and which ones are being reviewed (by pressing R). Finally, we can click on any of the versions to start reviewing them!
