Subtitles section Play video
-
many features in office, including Excel, are geared towards saving and sharing your files online.
-
This is done through one drive on online storage space for your documents and files that lets you access them even when you're away from your computer.
-
If you want to use one drive, make sure you're logged into Excel with your Microsoft account.
-
First, let's take a look at the regular Save Command on the quick access toolbar.
-
Just click, and if it's a new workbook, you'll be taken to the backstage view where you can choose where to save your file.
-
For now, let's save it to our computer.
-
Click the browse button to choose a location for your workbook, then enter a file name and click save when you're done.
-
Now, you can save it anytime by clicking the icon.
-
If you want to save a different version, maybe in a different location or with a different file name, you could go to save as in the backstage view and follow the same steps again.
-
You'll have the option of saving toe one drive or to this PC.
-
But if you primarily save files to your computer, you may want to change the default setting, so this PC is always selected.
-
To do that, click options in the backstage view, then select Save in the Left pane.
-
Now check the box that reads Save to Computer by default.
-
When you're done, click OK.
-
If you ever forget to save or if your computer crashes while you're working, don't worry.
-
The auto recovery feature saves a backup copy of your workbook automatically to recover an unsaved file.
-
All you have to do is reopen Excel and the document recovery Pain should appear on the left.
-
Here, you can access any recovered versions of the file by default.
-
Excel Auto saves a backup copy every 10 minutes, so if you're working on something for less than 10 minutes, you may not be able to use this feature.
-
You can also export your workbooks into an alternate file type by clicking export in the backstage view.
-
Exporting as a PDF is a good choice if you need to send a workbook to someone who doesn't have excel.
-
This format lets them view, but not edit the workbook.
-
Using a free program that anyone can download under change file type, you can access several other formats depending on what you need.
-
For example, if the person you're sharing with uses Excel 2003 or earlier, you'll need to send them an Excel 97 to 2003.
-
Workbook instead to share your workbook with others, click the share button in the top right corner.
-
Next, you'll have to upload your workbook toe one drive, so click on the option associated with your account.
-
Once it's uploaded, you can email an invitation for others to view or edit the file.
-
There are more ways to share at the bottom of the window, like attaching your workbook to an email or getting a shareable link.
-
If you have office 3 65 you can use the auto safe feature.
-
Once you upload your workbook toe one drive.
-
Whenever you make a change, it will automatically save your file.
-
However, if you want to disable this feature, click the button in the top left corner.
-
Keep in mind that if you deactivate auto saving, you'll need to click the save button every time you want to save.
-
With so many options, how you save and share your workbook is up to you.
-
Whether it's exporting, your file is a pdf or sharing your workbook online.
-
G C F.
-
Global.