When working with shared spreadsheets, it's especially useful to access past file versions. In this video, learn how to use OneDrive to restore previous versions of an Excel Online workbook.
- [Narrator] Oops, don't you hate that feeling when you make changes to a workbook that you didn't intend to. You've closed the file. the information has been saved. but you actually want to revert back to how the file used to look. Now, many of you may be aware that Excel Online automatically saves changes, and this might seem quite daunting, but don't stress. Excel Online has inbuilt version history capabilities. And what this means is if you've accidentally made changes that you didn't intend to, you can very quickly and easily restore the file to how it used to look. Now, I suggest you have XOL Version Management open to follow along with me and also have OneDrive open as well. Okay, let's go ahead and make some changes to the data that we can see here. I'm just going to select any cells at random, change the fill color to yellow and change the font color to red. And I'm going to go even crazier here and select these cells here and actually delete the data. Now, let's go ahead and save the file by clicking on the browser here. And in fact, those changes have already been automatically saved, but to make sure, let's close our tab here by clicking on the cross. Okay, now the changes that we just made have been automatically saved. To have a look here at the versions that have been saved for the file called XOL VersionManagement, let's click on the tick to the left hand side of the file. And then at the top of the screen, click on the three dots, if you can't see version history, and then select version history, and you'll see that we have two versions that have been created, one two minutes ago, which was just before we made all the crazy changes, and version two, which is the one that we really didn't intend to create. Now it's version one that we actually want to restore to. So, simply click on the three dots here and select restore, and you'll see that just like that, version three has been created, which should replicate the very first version that was created earlier. To double check, let's click away from this box here and open up XOL VersionManagement by clicking on it. Now you'll briefly see the changes that we made that we hadn't intended to, but in a split second, the file has been returned to how it used to look before we made all those crazy changes. And that's how we quickly and easily restore to a previous version of an Excel Online workbook.
Note: This course is for users who know the basics of the Excel desktop app, but are new to the web version, Excel Online. It emphasizes features that work differently in Excel Online. For basic Excel guidance, please see Excel Essential Training (Office 365) or Learning Excel 2019.
- Using Excel Online shortcuts
- Customizing your view
- Integrating the desktop version of Excel
- Sharing workbooks in Excel Online and OneDrive
- Inserting and reviewing comments
- Creating and editing charts
- Working with PivotTables and PivotCharts