Microsoft Excel logo

Unlike Google Sheets, Microsoft Excel doesn't enable autosave past default option. You can fix that easily as time-consuming as you take up a Microsoft 365 subscription. We're going to show you how to autosave Microsoft Excel workbooks to OneDrive.

If you keep striking Control+s (or Command+s on Mac) every few seconds, this method will ensure that you don't have any unsaved bring on in your Surpass workbooks. Information technology whole caboodle by automatically saving your workbooks to OneDrive as you keep working on them.

We've already mentioned that you take a Microsoft 365 subscription for this, and that means that you take 1TB of OneDrive cloud storage available, too. Plow ahead and open the OneDrive app, and succeed the onscreen operating instructions to set it up. This retributive requires you to log on to OneDrive, and Microsoft testament care the take a breather.

Mechanically Save Microsoft Excel Workbooks

Now is the time to active Microsoft Excel and fire risen a new workbook. Prime "File."

Click File

Click "New" in the left pane.

Click New

Select "Blank workbook" operating room whatsoever past template from the name. This will open a unweathered Excel workbook.

Click Blank workbook

Far at the top, you'll see an option labeled "AutoSave." Click the toggle next to AutoSave to change it to "Connected."

Click the toggle next to AutoSave

You'll figure a pop-up windowpane that asks you where you want to preserve your workbook. Click "OneDrive."

Click OneDrive

Type the file name and click "All right."

Click OK

That's all you postulate to act to enable autosave. From here on out, Surpass will keep delivery any modifications you make to this workbook. You'll sportsmanlike undergo to enable autosave once all time you start functioning on a new Excel workbook, and you won't motivation to preserve it again. You should note that you'll need an internet connexion for autosave to work correctly and sync these workbooks across devices.

A pop-up that confirms that your workbooks are being automatically saved

RELATED: What Your Function Keys Doh In Microsoft Excel

Change Where Excel Workbooks Are Rescued in OneDrive

By default, Microsoft Excel saves your Excel workbooks in the Documents folder in OneDrive. However, that's besides where altogether other Office documents bequeath be saved, which can lead to much of mare's nest. For better organization, you should create independent folders for various projects, or leastways one folder each for every Position app. Here's what you need to do.

Open some of your workbooks in Microsoft Stand out and dog "File."

Click File

Now, select "Save a Copy" from the left Elvis.

Click Save a Copy

Choose "OneDrive."

Click OneDrive

You undergo two options for creating new folders. The first method is aside clicking "More options" and adding folders victimisation the Explorer window that pops up.

Click More Options...

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

Click New Folder

Once you've through with that, dawn the folder.

Select the folder where you want to auto save Excel workbooks

Hit "Save."

Click Save

This testament take you rear to the Excel workbook. You can click the discover of your charge at the top to quickly check whether it's protected in the right folder.

Check the save folder location for Microsoft Excel workbooks

Now that you've seen how to autosave Microsoft Excel workbooks, you should also check verboten the best Microsoft Excel keyboard shortcuts.

RELATED: All the Superfine Microsoft Excel Keyboard Shortcuts

The preceding article may control affiliate links, which help support How-To Eccentric.