You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers Spreadsheet help : How to send individual sheets from the one spreadsheet

RE : Numbers Spreadsheets. I have 3 individual sheet tabs with seperate spreadsheets. I only wish to send one of the sheets by email. How can I do this without sending all 3 sheets?

Thanks

Kim

MacBook Pro 15″, OS X 10.11

Posted on Jul 12, 2023 7:00 PM

Reply
Question marked as Top-ranking reply

Posted on Jul 12, 2023 11:22 PM

Hi kimbo,


You have a single Spreadsheet, containing three Sheets, each of which apparently contains one Table.


IF the Tables are independent of each other, you can easily select one of the tables, Copy it, then Paste it into a new (and empty) Numbers spreadsheet Document. This will create a new spreadsheet, which can be emailed.


IF the Tables on the three sheets of the original document are inter-dependent (Information on one sheet is collected by another, and used in the new location), you will not be able to separate and email a working copy of the Sheets with working copies of the Table(s) on that sheet.

You can, however Select and copy that table, move to a different location (Sheet), then use 'Paste formula results' to create a static copy of the copied table.This copy may be copied and placed in an email.


Regards,

Barry

2 replies
Question marked as Top-ranking reply

Jul 12, 2023 11:22 PM in response to kimbo1309

Hi kimbo,


You have a single Spreadsheet, containing three Sheets, each of which apparently contains one Table.


IF the Tables are independent of each other, you can easily select one of the tables, Copy it, then Paste it into a new (and empty) Numbers spreadsheet Document. This will create a new spreadsheet, which can be emailed.


IF the Tables on the three sheets of the original document are inter-dependent (Information on one sheet is collected by another, and used in the new location), you will not be able to separate and email a working copy of the Sheets with working copies of the Table(s) on that sheet.

You can, however Select and copy that table, move to a different location (Sheet), then use 'Paste formula results' to create a static copy of the copied table.This copy may be copied and placed in an email.


Regards,

Barry

Numbers Spreadsheet help : How to send individual sheets from the one spreadsheet

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.