Placeholder Image

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.

many features in office, including Excel, are geared towards saving and sharing your files online.

Subtitles and vocabulary

Click the word to look it up Click the word to find further inforamtion about it