"Enable AutoSave in Excel: A Simple Step-by-Step Guide"
Autosaving your work in Excel is a lifesaver, ensuring you never lose progress. Here's how to turn it on, step by step, for various versions of Excel:
Let's dive into the process, explaining each step in detail for Excel 2016, 2019, and 365.
Enabling Autosave in Excel 2016 and 2019
Both Excel 2016 and 2019 use the same method to enable autosave:
First, click on the 'File' tab in the top left corner of your screen. Then, choose 'Options' at the bottom of the menu.
Setting Autosave every X minutes
In the 'Save' tab that appears, you'll see an 'Autosave' section. Here, ensure the 'Save autoRecover information every' box is checked. You can choose to autosave every 10, 30, or 60 minutes.
If you prefer to autosave more or less frequently, you can uncheck this box and click on the 'AutoRecover file location' link to specify a custom interval. This brings up the 'Excel Options' dialog box, where you can set a custom autosave interval.
Autosaving multiple times
By default, Excel autosaves multiple versions of your workbook, allowing you to revert to a previous version if needed. To ensure this feature is enabled, check the 'Keep this version if I close without saving' box.
You can also specify how many previous versions to keep by adjusting the 'Number of minutes between AutoSave sessions' slider. The higher the number, the more frequently Excel will autosave, but more space will be used on your hard drive.
Enabling Autosave in Excel 365
Excel 365, part of Microsoft's subscription service, has a slightly different autosave process:
In Excel 365, autosave is on by default, but you can still customize its settings:
Check Autosave status
To check if autosave is enabled, click on 'File', then 'Info'. Look for the 'Autosave' option under the ' bewusstlose_sequence' heading. If autosave is on, you'll see the message 'AutoSave is on' with a small cloud icon next to it.
If autosave is off, click the 'Turn AutoSave on/off' link to enable it.
Customizing autosave settings
To customize autosave settings, click on 'Options' at the bottom of the 'File' menu. In the 'Save' tab, look for the 'Save autoRecover information every' box and follow the same steps as Excel 2016 and 2019 to set your preferred autosave interval.
Additionally, you can choose to keep all autosaved versions by checking the 'Keep the last auto-saved version if I close without saving' box and adjusting the slider for the frequency of autosaved versions as needed.
With autosave enabled, you can work confidently in Excel, knowing your progress is safe. Happy spreadsheeting!