Excel: Saving and Sharing | Summary and Q&A

TL;DR
Learn how to save and share Excel files using OneDrive, export files to different formats, and utilize auto recovery and autosave features.
Key Insights
- 💾 OneDrive in Excel provides online storage for saving and accessing files from anywhere.
- 💾 Use the regular save command or save as to control the location and version of your files.
- 👻 Auto recovery saves backup copies of your workbook, and exporting to different formats allows compatibility with other programs.
- 💌 Sharing files via OneDrive, email, or shareable links offers flexibility in collaborative work.
Transcript
Read and summarize the transcript of this video on Glasp Reader (beta).
Questions & Answers
Q: How can I save my Excel files to OneDrive?
To save files to OneDrive, ensure you are logged in to Excel with your Microsoft account first. Then, click the share button and upload your workbook to OneDrive. You can then email invitations or share links to others to view or edit the file.
Q: How can I recover unsaved files in Excel?
If your computer crashes or you forget to save, reopen Excel, and the document recovery pane 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.
Q: Can I export my Excel files to different file formats?
Yes, you can export your workbooks to different file formats. In the backstage view, click on "Export" and choose the desired format. For example, exporting as a PDF is useful when you need to share the workbook with someone who doesn't have Excel.
Q: What is the autosave feature in Excel?
If you have Office 365, the autosave feature automatically saves your file in OneDrive whenever you make a change. To disable this feature, click the button in the top left corner. Keep in mind that you'll need to click the save button manually if you deactivate autosaving.
Summary & Key Takeaways
-
OneDrive is an online storage space in Excel that allows you to save and access files from anywhere.
-
Use the regular save command in the quick access toolbar to save files to your computer, or choose save as to save versions in different locations or with different file names.
-
Auto recovery feature saves a backup copy of your workbook every 10 minutes, and you can export files to different formats like PDF.