How to share a single Excel worksheet

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Is it possible to share or send a single Excel tab or worksheet from an entire spreadsheet?

Sharing a single worksheet or tab isn’t possible. Excel’s sharing features work on the workbook or entire document level.

But it is possible to send out or share a single worksheet/tab with a little workaround.

img 587f738fb7dca - How to share a single Excel worksheet

Definitions

These terms get tossed around at times but for this article the difference is important.
Worksheet – a single sheet or tab in an Excel document
Workbook– all the worksheets or tabs in an Excel document
Spreadsheet is a somewhat old-fashioned term. It could mean either a single worksheet or an entire workbook.

Copy to another workbook

The trick is to save a copy of the entire workbook then delete the unwanted tabs from the copy of the document.

how to share a single excel worksheet 12047 - How to share a single Excel worksheet

Another option is to use the Move or Copy … option on the same right-click menu. One of ‘To book:’ options is (new book) to create a new Excel document. Make sure you click ‘Create a copy’ to keep the worksheet/tab in the current workbook.

how to share a single excel worksheet 12049 - How to share a single Excel worksheet

You can send or share the new workbook in the usual way.

Ensure that the shared worksheet can operate of the private sheets. There’s no point in sharing or sending a worksheet which depends on inaccessible sheets to work.

subs profile e1563205311409 - How to share a single Excel worksheet
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address