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.

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

Posted on Jul 20, 2021 6:32 AM

Reply
Question marked as Top-ranking reply

Posted on Jul 20, 2021 7:18 AM

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.

2 replies
Question marked as Top-ranking reply

Jul 20, 2021 7:18 AM in response to zamboknee

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.

Jul 20, 2021 8:49 AM in response to zamboknee

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

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