Inserting Numbers Spreadsheet into Pages

I finished building a Numbers SS tonight and was preparing to insert the Table data into a Pages document. I prefer to keep the info in the SS and then use the Table data in a Layout prog. when applicable. Well, even though i can do this same thing with M$ Office, I can't seem to find a way to do it in iWork '08. I tried copying, dragging dropping, and even opening. No deal. I tried dragging the file onto the open Pages doc—eh uh. I received a big shake of the finger on that one.

Can someone suggest a way to do this—someone that has done it and it worked?

MBP, Mac OS X (10.5.1)

Posted on Jan 1, 2008 7:38 PM

Loading page content

Page content loaded

Welcome to Apple Discussions.

I think this will do what you're asking: in the Thumbnails, click on the table you want and then Copy. In Pages Layout click in the page (not the Thumbnail) you want the SS in and then Paste. You may have to resize the table.

Weird, does this work for you? For me it completely drops the table. All data shows up but the table is completely gone.

Here is an example where I selected the table and graph, copied then paste into Pages:

Make sure the the selection shows the "open boxes" at the corners of the table.

AHHH. For some reason the '06 opened. I just figured that out. It works great in 08. 🙂 Man that was frustrating. I thought 06 would have been removed. Thank you all for your help.

If you have both versions of iWork, then you have both versions on your HD. Once you are comfortable with '08, '06 can be deleted.

when I try this, the data in some cells changes or is missing, it is like the formulas in the cells are looking for the wrong thing, shouldn't the copy/paste just put the format and VALUES from numbers into pages? what is wrong? this is always such a straight forward process with excel and word.

I thought that this thread would solve my problem, but it doesn't. I want to insert a Numbers document that has a bunch of arrows and text boxes and things like that, into a Pages document. When I copy either the entire Numbers document or Table 1, I get the text and colors but the arrows are all over the place and things aren't formatted properly, even the column headings aren't formatted as they are in the Numbers document. Is there some way to combine the two documents?

I wanted to exactly this today in Mail. What I found after reading this thread was this:

one sheet with one table

select and copy the table, you get the text.
select and copy the sheet, you get the table.

You might select all of the objects then group then copy and paste. See below.

Select Objects:

Select Group:

Copy then Paste into Pages:

Thanks, that sounded as if it would work, but it doesn't. When I select everything (either manually or using Select All) and then group, copy and paste into the Pages document, I get only the things other than the chart (arrows, bubbles, text box) and they aren't the same size as in Numbers, so some things get cut off. I could probably deal with that, but not with losing the entire chart as well as the column and row headings. And yes, the open boxes at the top, bottom & sides of the chart showed before I did "group" so I'm reasonably confident everything was selected. Oh, and when I say "chart" it's just a spreadsheet with rows and columns of information, mostly text. I was using Numbers essentially as a layout tool, not to do any computations at all. It worked very well - I could put arrows where I wanted them and color things and add text boxes. But if I can't move it into a Word Processing document it's not nearly so useful.