قالب وردپرس درنا توس
Home / Tips and Tricks / Automatically save Microsoft Excel files to OneDrive

Automatically save Microsoft Excel files to OneDrive



Microsoft Excel logo

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̵

7;t have any unsaved work in your Excel workbooks. It works by automatically saving your workbooks to OneDrive while you keep working on them.

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 File

Click on “New” in the left pane.

Click on New

Select “Blank Workbook” or another template from the list. This will open a new Excel workbook.

Click Blank 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’.

Click the switch next to Auto save

You will see a popup asking where you want to save your workbook. Click on ‘OneDrive’.

Click on OneDrive

Type the file name and click “OK”.

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.

A popup confirming that your workbooks are automatically saved

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’.

Click on File

Now select “Save a copy” from the left pane.

Click Save a Copy

Choose ‘OneDrive’.

Click on OneDrive

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.

Click More options ...

The second method involves clicking the “New Folder” button and creating a folder in OneDrive from Microsoft Excel itself.

Click New Folder

Once you’ve done that, click on the folder.

Select the folder where you want to automatically save Excel workbooks

Press ‘Save’.

Click on Save

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.

Check the save folder location for Microsoft Excel workbooks

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




Source link