Saving and Sharing Workbooks in Excel 2016

When working in Microsoft Excel 2016, saving and sharing your workbook are two of the most important skills to learn. Saving helps you keep your data safe for later use, while sharing allows others to view or edit your work. Let’s explore how you can easily do both.

Saving Your Workbook

Whenever you create a new workbook, it’s smart to save it right away. Saving your file makes sure your work isn’t lost if something unexpected happens. You can save it on your computer or in the cloud using OneDrive.

  • To save your workbook: Click on File → Save As.
  • Choose where you want to save: This PC or OneDrive.
  • Type a name for your file.
  • Click Save.
Tip: To save quickly, press Ctrl + S on Windows or Command + S on Mac.

Saving to OneDrive

Excel 2016 makes it easy to save files online using OneDrive. OneDrive is a cloud storage service from Microsoft that lets you access your files from any device with an internet connection.

To use OneDrive:

  • Sign in with your Microsoft account in Excel.
  • Choose OneDrive when saving the file.
  • Your workbook will now be available online anytime, anywhere.

Sharing Your Workbook

Once your workbook is saved, you can easily share it with others. Excel 2016 gives you several sharing options.

  • Share via OneDrive: Upload your workbook to OneDrive and click the Share button. You can invite people by entering their email addresses or share a link.
  • Send as an Attachment: Go to File → Share → Email and choose to send your workbook as an attachment.
  • Export as PDF: You can also export your workbook as a PDF for easy viewing.
Tip: When sharing, you can choose whether others can edit or only view your file.

Why Saving and Sharing Matter

Saving your workbook prevents data loss and keeps your work safe. Sharing, on the other hand, improves collaboration. Whether you’re working on a project, managing data, or creating reports, both are essential for efficient teamwork and productivity.

5 FAQs on Saving and Sharing Workbooks

1. How do I save a workbook for the first time?

Go to File → Save As, choose the location, enter a name, and click Save.

2. Can I access my saved workbook from another computer?

Yes. If you save your workbook in OneDrive, you can access it from any device with an internet connection.

3. How do I share a workbook in Excel 2016?

Click File → Share and choose how to send it — via OneDrive, email, or link sharing.

4. What’s the difference between saving locally and saving on OneDrive?

Saving locally keeps the file on your computer, while OneDrive stores it online for access anywhere.

5. Can I allow others to edit my workbook?

Yes. When sharing via OneDrive, choose “Can edit” to let others make changes to your file.

Conclusion

Saving and sharing workbooks in Excel 2016 are simple yet powerful features. Whether you store your files locally or on OneDrive, knowing these steps ensures your work stays safe and easy to access. With sharing options, teamwork becomes smoother, faster, and more organized.

You May Also Like

Loading...