SHARE, EXPORT

Share:
In MS-Excel, "Shared Workbooks" is an older feature that allows you to collaborate on a Workbook with multiple people. This feature has many limitations and has been replaced by co-authoring. Co-authoring is available in certain versions of Excel, including Excel 2016 for Office 365.
 
These days more and more people are using Microsoft Excel for team work. In the past, when you needed to share an Excel Workbook with someone, you could send it as an email attachment or save your Excel data to PDF for printing. While fast and convenient, the former method created multiple versions of the same Workbook, and the latter produced a secure though non-editable copy.
 
The recent versions of Excel 2016 make it easy to share and collaborate on Workbooks. By sharing an Excel file, you are giving other users access to the same Workbook and allow them to make edits simultaneously, which saves you the trouble of keeping track of multiple versions.
 
Another way to share an Excel Workbook is to save it to OneDrive, invite your colleagues to work on it, and see each other's changes instantaneously. Microsoft calls it co-authoring.
 
In Excel 2016, you can simply click the Share button in the upper-right corner, save the Workbook to a cloud location (OneDrive, OneDrive for Business, or SharePoint Online library), type email addresses in the Invite people box, separating each with a semicolon, and then click the Share button on the pane (please see the screenshot below).
 
Clicking the Share button will send an email message to each person, a copy will be sent to you too, just in case. If you'd rather send the link yourself, click Get a sharing link at the bottom of the pane instead.
 
When your colleagues receive an invitation, they simply click the link to open the Workbook in Excel Online, and then click Edit Workbook > Edit in Browser to edit the file. Excel 2016 for Office 365 subscribers (as well as users of Excel Mobile, Excel for iOS and Excel for Android) can co-author in their Excel desktop application by clicking Edit Workbook > Edit in Excel.
 
How to share current Worksheet for edit it with someone else via email?
Select File Menu => Click Share => Click OneDrive Personal (you need an internet connection) => Type a name for your workbook (if you are not save) and then Click OK => Type the email (whom you want to share with) in Task Pane => Select Can Edit in the Drop-down box and if you want to say something regarding edit it, type it in the message box => Click Share.
 
For more understanding, look at the screenshot please:

Export:
In MS-Excel 2016, there is a command “Export” in the sector of File menu, that is using to export the current Excel Worksheet(file) to another format of file such as “.PDF”, “.CSV”, “.XLSM”, “.TXT”, “.XLTX”, “.XLS” and more. When the users need to export current Worksheet, the users should be considered on the data type that they would be wanted because Excel can support only the files type which are preferred and included in change type of files in export section (as I given above).
 
How to export current worksheet to a “.PDF” file format?
Select File Menu => Click Export => Select Create PDF/XPS Document => Click Create PDF/XPS Tool => Type a name and select a location that you want to save the file => Click Publish.

For more understanding, look at the screenshot please: