Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Inserting Numbers Spreadsheet into Pages

Hello,

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

Reply
14 replies

Feb 19, 2008 3:46 PM in response to WWJD

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?

Feb 20, 2008 1:28 PM in response to WWJD

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.

Feb 20, 2008 2:00 PM in response to JanM

OK, I tried to group the tables but only the chart and graphic objects would group. Tables do not group but are copied in sequence but not in the layout in Numbers. Can objects in Pages be made to float (in Word you can change this behavior)? Here's my trial:

Numbers Selection:
User uploaded file

Pages Paste Page 1 (Tables not grouped as in Numbers):
User uploaded file

Pages Paste Page 2 (Charts & Graphic Object Paste true):
User uploaded file

Regards,

Feb 21, 2008 1:56 PM in response to WWJD

I guess the answer is that if the Numbers document is simple it can be copied and pasted into Pages but if it's complicated (mine has very complicated layout - arrows with description in text boxes that are lined up with the arrows and the arrows go from one chart to another) it just isn't going to work.

I'm going to try to reverse approach and put the Word Processing things into the Numbers document in text boxes before and after the chart - that should work, I hope.

Inserting Numbers Spreadsheet into Pages

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