Share a section of a workbook

Whether collaborating through Teams or on the web, you may want to share information from a workbook. You can share the entire workbook, but often it’s safer, faster, and more efficient to share just a section of the workbook for viewing or editing. You can easily share with others a link to a specific sheet, range, table, or chart. First, you create a link to the shared section of a workbook. Then you send or make available the link to recipients. Finally, recipients can simultaneously view or edit the workbook section.

1. Open the workbook in Excel for the web.
2. Select the sheet, range, table, or chart.
3. Right click the selection, and then select Link to this Sheet, Range, Table, or Chart. The Copy Link dialog box appears.

The link is now in the Office Clipboard. For more information, see Copy and paste using the Office Clipboard.

Once the shared workbook section link is created, recipients can use it in the following common ways:

1. When a recipient receives the shared link in email, they can select it. They can also copy and paste the link into the browser address bar.
2. The workbook opens in Excel for the web. The range, table, or chart is highlighted with a border for easy identification.

1. Open or switch to Teams.
2. Typically, the copied link is shared in the Teams chat with one or more recipients. The link can also be posted in a channel in Teams.

Tip Right click the workbook section to see additional commands including Edit in Teams, Open in Desktop App, Open in Browser, Download, and Copy Link.

Note Opening the workbook by using Excel on the desktop or by downloading the workbook removes the highlight from the range, table, or chart.