Unlike Google Sheets, Microsoft Excel does not enable auto-save by default. You can easily fix that as long as you have a Microsoft 365 subscription. We will show you how to automatically save Microsoft Excel workbooks to OneDrive.
If you press Control + s (or Command + s on Mac) every few seconds, this method will make sure you don̵
We already mentioned that you need a Microsoft 365 subscription to do this, and that means you also have 1 TB of OneDrive cloud storage available. Go ahead and open the OneDrive app and follow the onscreen instructions to set it up. This just requires you to sign in to OneDrive and Microsoft will do the rest.
Automatically save Microsoft Excel workbooks
Now is the time to open Microsoft Excel and start a new workbook. Select file. “
Click on “New” in the left pane.
Select “Blank Workbook” or another template from the list. This will open a new Excel workbook.
At the very top, you will see an option labeled ‘Auto save’. Click the toggle next to Auto Save to change it to ‘On’.
You will see a popup asking where you want to save your workbook. Click on ‘OneDrive’.
Type the file name and click “OK”.
That’s all you need to do to turn on auto-save. From now on, Excel will save any changes you make to this workbook. You don’t have to enable auto-save once every time you start working on a new Excel workbook and you don’t have to save it again. Keep in mind that you need an internet connection for auto-save to work properly and to sync these workbooks across devices.
RELATED: What your function keys do in Microsoft Excel
Change where Excel workbooks are saved in OneDrive
By default, Microsoft Excel saves your Excel workbooks in the Documents folder in OneDrive. However, all other Office documents are also stored there, which can lead to a lot of clutter. For better organization, you should create separate folders for different projects, or at least one folder for each Office app. Here’s what to do.
Open one of your workbooks in Microsoft Excel and click ‘File’.
Now select “Save a copy” from the left pane.
You have two options to create new folders. The first method is to click “More Options” and add folders using the Explorer window that appears.
The second method involves clicking the “New Folder” button and creating a folder in OneDrive from Microsoft Excel itself.
Once you’ve done that, click on the folder.
Returns to the Excel workbook. You can click on the name of your file at the top to quickly check if it is saved in the correct folder.
Now that you have seen how to automatically save Microsoft Excel workbooks, you should also check out the best Microsoft Excel keyboard shortcuts.
RELATED: All the best Microsoft Excel keyboard shortcuts