How to Turn on AutoSave in Excel
AutoSave is a feature in Excel that saves your work periodically and automatically. It is a convenient feature that prevents the loss of data in case of a power outage or if the program crashes. In this article, we will discuss how to turn on AutoSave in Excel.
Step 1: Open Excel and click on the “File” tab at the top left corner of the window.
Step 2: Click on “Options” at the bottom of the list.
Step 3: In the Excel Options dialog box, click on “Save” from the list on the left.
Step 4: Check the box that says “Save AutoRecover information every” and specify the time interval for AutoSave.
Step 5: Under “Keep the last autosaved version if I close without saving,” make sure the box is checked.
Step 6: Click “OK” to save the changes and close the dialog box.
Note: The default time interval for AutoSave is set to 10 minutes. You can change this time interval to suit your needs.
Once you have turned on AutoSave, Excel will automatically save your work at the specified time intervals. You can continue working without worrying about losing your work if Excel crashes or shuts down unexpectedly. You can also view the last autosaved version of your work by opening the file and clicking on the “File” tab, followed by clicking on “Manage Workbook” and then “Recover Unsaved Workbooks.”
In conclusion, turning on AutoSave in Excel is a simple and important step that ensures the safety of your work. It is an excellent feature that prevents the loss of data due to power outages, program crashes, or accidental closing of files. Follow the steps above to turn on AutoSave in Excel and protect your work.