How can I move a sheet to another Numbers document?
I am using Numbers 3.5.2 on a new MBP. Is there any way to mote a sheet from one document to another.
This is simple in Excel but I can't find it in Numbers
Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
I am using Numbers 3.5.2 on a new MBP. Is there any way to mote a sheet from one document to another.
This is simple in Excel but I can't find it in Numbers
DonHalt wrote:
I am using Numbers 3.5.2 on a new MBP. Is there any way to mote a sheet from one document to another.
This is simple in Excel but I can't find it in Numbers
Actually it's very simple in Numbers too, very similar to Excel. You don't have to select all the tables, etc. Just look up toward the top, not down as in Excel..
When you're in the sheet you want to copy, click choose 'Copy Sheet' from the dropdown by the sheet's name (in the "tab" at the top):
Then go to a sheet in the other document. Choose 'Paste Sheet.' That's it!
If you want to move a sheet rather than copy it, choose 'Cut Sheet' instead of 'Copy Sheet' in the first step.
SG
DonHalt wrote:
I am using Numbers 3.5.2 on a new MBP. Is there any way to mote a sheet from one document to another.
This is simple in Excel but I can't find it in Numbers
Actually it's very simple in Numbers too, very similar to Excel. You don't have to select all the tables, etc. Just look up toward the top, not down as in Excel..
When you're in the sheet you want to copy, click choose 'Copy Sheet' from the dropdown by the sheet's name (in the "tab" at the top):
Then go to a sheet in the other document. Choose 'Paste Sheet.' That's it!
If you want to move a sheet rather than copy it, choose 'Cut Sheet' instead of 'Copy Sheet' in the first step.
SG
Hi Don,
You can do this by selecting all the tables in your sheet and copying. Move to your new doc and paste. As long as there are no links ot other sheets your formulas will still work.
quinn
So unlike Excel (Move or Copy tab to an new or existing workbook) it's a copy and paste of values/formulas action not actually moving or copying the entire sheet (formats etc) to another .numbers doc?
How can I move a sheet to another Numbers document?