add numbers document as a sheet
Is there a way to add a Numbers document as a Sheet into another Numbers document?
I've tried copy and pasting but it gets a little tricky
MacBook Pro 15″, macOS 10.14
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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Is there a way to add a Numbers document as a Sheet into another Numbers document?
I've tried copy and pasting but it gets a little tricky
MacBook Pro 15″, macOS 10.14
If your other document is all in one sheet you can Select All, Copy, then paste into a blank sheet in the other document. All the interrelated formulas should continue to work as they did, though some functions like INDIRECT might fail if the sheet name was in the formula and is different now. All interrelated tables and charts need to be on the same sheet so they can all be copy/pasted at the same time. Stand-alone tables and objects can be copy/pasted individually.
If your other document is all in one sheet you can Select All, Copy, then paste into a blank sheet in the other document. All the interrelated formulas should continue to work as they did, though some functions like INDIRECT might fail if the sheet name was in the formula and is different now. All interrelated tables and charts need to be on the same sheet so they can all be copy/pasted at the same time. Stand-alone tables and objects can be copy/pasted individually.
You can also do this:
In the document that you want to "add" to another document:
Hover over a sheet "tab", click the v to its right and select Copy Sheet.
In the document to which you want to add that sheet:
Hover over any sheet "tab", click the v to its right, and select Paste Sheet.
Repeat with other sheets as necessary.
SG
add numbers document as a sheet