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.
I'm a complete novice with Numbers so forgive me if this is a rather basic question . I have a large spreadsheet which I'd like to sub divide into probably 5 separate sheets . I've created a simple template & i'd need all sheets to have this appearance . So the two questions are :- How can I add a sheet to my document that is in the form of the Template ? I can only add blank documents . Or is there a way of combining separate spreadsheets int a single document , Cheers
iMac, OS X 10.11
ashtony Said:
I. "How can I add a sheet to my document that is in the form of the Template ? I can only add blank documents"
Two thoughts on this:
A. Creating a Unique Template:
It takes a few tries, but once created, you would get the gist of it. When needed, you would select that template.
And...
B. Retaining the Formatting:
Go Here: Use sheets in Numbers on Mac - Apple Support
Also, if you are looking to retain the formatting (IOW: Keep it after it is copied), then simply duplicate it. Click the down arrow next to the sheet name, then select Duplicate.
---
II. "Or is there a way of combining separate spreadsheets int a single document"
No. You cannot copy 2 or more sheets into a new book (document). That is just not a feature built into Numbers.
Recommend this to Apple:
ashtony Said:
I. "How can I add a sheet to my document that is in the form of the Template ? I can only add blank documents"
Two thoughts on this:
A. Creating a Unique Template:
It takes a few tries, but once created, you would get the gist of it. When needed, you would select that template.
And...
B. Retaining the Formatting:
Go Here: Use sheets in Numbers on Mac - Apple Support
Also, if you are looking to retain the formatting (IOW: Keep it after it is copied), then simply duplicate it. Click the down arrow next to the sheet name, then select Duplicate.
---
II. "Or is there a way of combining separate spreadsheets int a single document"
No. You cannot copy 2 or more sheets into a new book (document). That is just not a feature built into Numbers.
Recommend this to Apple:
If by "sheet" you mean sheet in the Numbers sense (the "tab", not a table with the rows and columns) then you can copy-paste your model sheet anywhere by going to the sheet name in the tab at the top and choosing Copy Sheet from the dropdown when you click the "v". The select another sheet (even in a different document), go the dropdown by the name in the tab at the top of any sheet and choose Paste Sheet.
If you're creating similar sheets in the same document you can just choose Duplicate in that same dropdown menu.
If, on the other hand, you mean you have set up a table the way you like it, and want to create others just like it, then just click in it, click the concentric circles "bulls-eye" upper left, command-c to copy, click the canvas, and command-v to paste.
Or, if you mean you have set up a document the way want it and will want to create similar documents with the same setup, then you can go to File > Save as Template ... and give that a name. Then to start a new document just like it, File > New and choose your template in the template chooser. It will be in the 'My Templates' section.
SG
Numbers
