AutoBackup makes a copy of your spreadsheet when you first save it. If you make changes to your original spreadsheet and save it but then change your mind about the changes, you can open the backup copy. Each time you save the original spreadsheet, AutoBackup updates the backup copy so it’s up to date and one version behind the original. To set it up, start creating your worksheet as usual. Then:

  1. Go to File > Save As.
  2. For Excel 2016, click “More options…” under the save location. Earlier versions of Excel: skip this 
  3. Click the Tools button then General Options in the Save As dialog window.
  4. Check the box next to “Always create backup”
  5. Click OK.
  6. Click Save in the Save dialog window. Now, every time you make a change in the original spreadsheet and save it, the backup file will be updated to reflect your spreadsheet before that last save.

How to Freeze Rows and Columns in Excel 2016How to Remove Duplicate Data in Excel 2016How to Create a Waterfall Chart in Excel 2016