Excel's ability to automatically backup your document at a chosen time interval was explored in the last lesson: Lesson 1-10.
This lesson will show you how to view the automatic backups and to revert to an earlier version if you've messed up the current version. You can even cut sections from an older version of a workbook and paste them into the current version.
You'll need a watch or a clock with a seconds hand for this lesson.
For this lesson, you need to open the sample file: Mary from your Sample Files Folder if it isn't already opened.
In the last lesson, Lesson 1-10, you set the time interval for automatic backups to one minute. If you're not completing this course sequentially. you will need to go back to this lesson and make sure that this setting is set to one minute.
I'm now going to add some more text to cells A4 and A5: "And everywhere that Mary went the lamb was sure to go".
Look at your watch or clock now and wait for a little over one minute. Excel should have automatically saved a new version of the workbook.
Here's how to make sure that the auto save has happened. Click the File tab on the ribbon. You should see an Autosave version alongside the Manage Versions button. If you don't see the Autosave version, click the Back button and wait another minute. And then click the File tab again, but don't move on to the next step until it's appeared.
Now I'm going to further modify the worksheet. I'm going to type in cells A7 and A8: "It followed her to school one day, it was against the rules". And I'm now going to save this workbook, so I'll click the Save button on the Quick Access Toolbar.
Now I'd like to revert to the earlier version that Excel has automatically saved. To do this, I click the File tab and then click on the autosaved file. And you can see that I'm now looking at that earlier version, before I added any text to cells A7 and A8.
I may decide that I want to revert to this version and lose the changes that I made when I added more text. To do that, I'll click the Restore button.
When I click the Restore button Excel warns me that I'm going to overwrite the last saved version with this previous version of the workbook. And because that's what I want to do, I'll click the OK button.
Before leaving this lesson we need to reset the Autosave Interval, because you'll be making rather too many backups if you continue to backup every minute. So I'll click the File tab on the ribbon, then Options on the left hand Menu Bar, and then Save on the left hand Menu Bar. And "Save AutoRecover information every", I will wind back up to the 10 minute default.
I'll now click OK, and you've now completed Lesson 1-11 Use the Versions Feature to Recover an Earlier Version of a Workbook.