Automatically saving Excel files to OneDrive will save you more time. But unlike Google Sheets, Microsoft Excel doesn’t have autosave enabled by default. You can fix this problem easily if you subscribe to Microsoft 365. But at Anonyviet, a place that won’t pay for anything will teach you how to automatically save Excel files to OneDrive for free.
You can also press Save or Ctrl + S every 1.2 minutes, but I don’t think anyone does that right. Not because it takes time, but because it bothers. You can’t be busy calculating the company’s financial file while clicking Save. Sometimes it even makes you forget what you’re doing, and with a job as precise as this, it only takes a little distraction to sell your house.
Automatically save Excel files to OneDrive
First, you need to open Excel and create a new Workbook by selecting “File”.
Press “new” in the menu on the left.
Select “Blank workbook” or any other template from the list. So you have created a new workbook already.
You will see an option named “AutoSave” in the upper left corner. Click the switch next to AutoSave to switch to “On”.
You will see a window pop up asking where you want to save your workbook. Click “OneDrive.“
Enter the file name and press “OK“.
That’s all you need to do to enable the feature autosave. From now on, Excel will automatically save any modifications you make to this workbook. You only need to turn on autosave once each time you start working on a new workbook and you won’t need to manually press save again. Note that you need an Internet connection for autosave to work properly and to synchronize these workbooks across devices.
Change where to save Workbooks in OneDrive
By default, Microsoft Excel saves your workbook in the Documents folder in OneDrive. However, that’s also where all the other Office documents will be saved, which is a bit messy already. For better folder organization, you should create separate folders for different projects, or at least one folder for each Office application.
Open any workbook in Microsoft Excel and press “File”.
Now, select “Save a Copy” in the left menu.
You have two options to create a new folder. The first option is to click “More options” and add the folders using Windows Explorer.
The second option is to click “New Folder” and create a folder in OneDrive from Microsoft Excel.
When done, click on the newly created folder.
This will return you to the Excel workbook. You can click on your file name at the top to quickly check if the file is saved in the correct folder.
So you just know how to automatically save Excel files to OneDrive. You can also learn many other Excel tips like these 20 tricks that will make you an Excel expert.