Repost of discussion from wrong area

Question

Level 1

32 points

Repost of discussion from wrong area

I am attempting to create a template for a work in progress situation whereby the template book would contain several different sheets using page format that have already been defined in existing spreadsheets.

I do not quite understand the "New" terminology of wording from previous AppleWorks and Excel wordings. What I am referring to here is after a spreadsheet is completely formatted, i.e. columns sized, rows sized, fonts selected, font size selected, formulas entered, etc. etc. etc., to what this is now called, or even if there is any such thing.

Basically, what I want to do is get the complete format of an existing document page and add that as a sheet into a book that will become a template of a book of sheets.

I have posted something similar to this over the years and have as yet to discover, to my satisfaction, what this is now called and if it is even possible to even program this capability into the new Pages.

Any Ideas?

Sparkgapper

iMac, OS X Mountain Lion (10.8.5), DualBoot with Snow Leopard

Posted on Jul 7, 2015 5:48 AM

Reply

Answer 1

Yellowbox

Level 7

20,383 points

Jul 7, 2015 6:30 AM in response to Sparkgapper

Hi Sparkgapper,

I saw your discussion on the Pages for Mac forum. Add pages to a spreadsheet book using previous perameters

Welcome to the Numbers for Mac forum 🙂.

In Numbers, you have a Document (file, or 'workbook' in the Excel world)

Each Document (in Numbers) can have one or more Sheets.

Each Sheet has a "canvas" (blank area).

On each Sheet, you can place "objects" such as tables, graphs, text boxes or Shapes.

You can create a Numbers document (file) and Menu > File > Save as Template for future use.

If you want to add that table to other Sheets,

In Numbers '09 (Numbers 2) click on the table icon in the left panel

That will select the whole table.

Menu > Edit Copy. That will copy the whole table.

Now insert another Sheet. Click on the Sheet icon. That inserts another Sheet with a default table (Sheet 2, Table 1).

You can delete the default table and Paste your own table onto the canvas.

I hope this makes sense.

Please call back with questions. There are many helpful users in this forum.

Regards,

Ian.

Reply

Answer 2

Sparkgapper Author

Level 1

32 points

Jul 7, 2015 8:06 AM in response to Yellowbox

I just discovered partially what I am looking for and a workaround to achieve what I need.

Basically (in the new terminology as I see it), a BOOK is a collection of Sheets that contain one or more Tables (work spaces). The major problem with multiple Tables to a Sheet is that their spaces run contiguous but with adjustable blocking to contain the object put on them, default is spread sheet cells. This adjustability creates its own problem, particularly in the pagings of the different sized Tables.

I know there is a lot more to this than meets the eye but right now I am very much aware of my own limitations in correlating new information into relationship with older knowledge and that rate of educationability.

Back to the original question:

I just did a Copy/Paste of a sheet/table (I thought) from one document to another but on the paste it only added the table area as the second table on the existing sheet rather than as a new sheet and table. The only workaround I can think of for this is to add a sheet to which the ported table is to be attached then delete table 1 after the attachment.

Is there some way that the Copy/Paste can be used to add a sheet/table instead of just a sheet?

Sparkgapper

Reply

Answer 3

Hiroto

Level 5

7,461 points

Jul 7, 2015 9:53 AM in response to Sparkgapper

Hello

In order to copy/past a sheet -

1) select a sheet in Sheets pane in source document;

2) select a sheet in Sheets pane in destination document;

3) perform paste;

If you want to preserve the original sheet name, make sure sheet with the same name is not present in the destination documuent. E.g.,

2a) (Sheet 1 is not present in destination)

3a) (Original name Sheet 1 is preserved in paste operation)

Hope this helps,

H

Reply

Answer 4

t quinn

Level 5

7,043 points

Jul 7, 2015 10:56 AM in response to Sparkgapper

Hi Sparkgapper,

Hiroto's solution looks good for Numbers '09. In case your have upgraded to 3:

Duplicate.

quinn

Reply

Answer 5

Hiroto

Level 5

7,461 points

Jul 7, 2015 11:19 AM in response to Hiroto

Oops.

The line -

1) select a sheet in Sheets pane in source document;

should have been -

1) select a sheet in Sheets pane in source document and copy;

Of course ! 🙂

H

Reply

Answer 6

Yellowbox

Level 7

20,383 points

Jul 8, 2015 4:42 AM in response to Sparkgapper

Hi Sparkgapper,

I find this Numbers '09 User Guide very helpful

https://manuals.info.apple.com/MANUALS/0/MA664/en_US/Numbers09_UserGuide.pdf

Click on the link to open it in your browser, then Save to create a PDF document on your computer.

The User Guide explains how Numbers '09 works (sheets, tables, copy, paste and so on...)

Regards,

Ian.

Reply

Answer 7

Sparkgapper Author

Level 1

32 points

Jul 8, 2015 6:31 AM in response to Yellowbox

Tks YellowBox for that link. Now, all I have to do is find the time to read this thing several times, or as much as these aged eyes will allow (in middle of Cataract removal/implants will will hopefully help considerably).

Hopefully, the NEW terminologies will not be too bad to allow assimilation of not only the basic facts but the primary details and their workings.

Tks again

Sparkgapper (and ANCIENT radioman)

Reply

Answer 8

Yellowbox

Level 7

20,383 points

Jul 8, 2015 6:49 AM in response to Sparkgapper

Hi Sparkgapper,

When you save that User Guide as PDF, double click to open it in Preview. You will see a search box. Type Sheet (for example) to find all references to Sheet.

Regards,

Ian.

Reply