Skip navigation
This discussion is archived

Inserting Numbers Spreadsheet into Pages

5611 Views 14 Replies Latest reply: Feb 21, 2008 4:25 PM by WWJD RSS
yetsirah Level 1 Level 1 (0 points)
Currently Being Moderated
Jan 1, 2008 7:38 PM
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)
  • Walt K Level 4 Level 4 (2,895 points)
    Currently Being Moderated
    Jan 1, 2008 7:50 PM (in response to yetsirah)
    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.

    Walt
    iMac G5, Mac OS X (10.4.10)
  • WWJD Level 6 Level 6 (15,815 points)
    Currently Being Moderated
    Jan 1, 2008 7:59 PM (in response to yetsirah)
    Here is an example where I selected the table and graph, copied then paste into Pages:

    Photobucket

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

    Regards,
    MDD Dual 1GHz 2GB RAM / QS 867MHz 1.5GB RAM, Mac OS X (10.5.1), 2930 SCSI / 16x DVR-110D / Yamaha 01X / 1GB Shuffle x 2 / 4GB Nano :o)
  • WWJD Level 6 Level 6 (15,815 points)
    Currently Being Moderated
    Jan 2, 2008 1:07 PM (in response to yetsirah)
    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.

    Regards,
    MDD Dual 1GHz 2GB RAM / QS 867MHz 1.5GB RAM, Mac OS X (10.5.1), 2930 SCSI / 16x DVR-110D / Yamaha 01X / 1GB Shuffle x 2 / 4GB Nano :o)
  • NYCTREE Level 1 Level 1 (0 points)
    Currently Being Moderated
    Jan 8, 2008 2:37 PM (in response to Walt K)
    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.
    G5, Mac OS X (10.5.1)
  • JanM Level 1 Level 1 (0 points)
    Currently Being Moderated
    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?
    MacBook Pro, Mac OS X (10.4.10), iPhone 8GB
  • J Douglas Rogers Level 1 Level 1 (25 points)
    Currently Being Moderated
    Feb 19, 2008 4:24 PM (in response to Walt K)
    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.
    G4 15" powerbook, Mac OS X (10.4.3), G3 desktop/imac/powermac 8300
  • WWJD Level 6 Level 6 (15,815 points)
    Currently Being Moderated
    Feb 19, 2008 4:53 PM (in response to JanM)
    You might select all of the objects then group then copy and paste. See below.

    Select Objects:
    Photobucket

    Select Group:
    Photobucket

    Copy then Paste into Pages:
    Photobucket

    Regards,
    MDD Dual 1GHz 2GB RAM / QS 867MHz 1.5GB RAM, Mac OS X (10.5.2), 2930 SCSI / 16x DVR-110D / Yamaha 01X / 1GB Shuffle x 2 / 4GB Nano :o)
  • JanM Level 1 Level 1 (0 points)
    Currently Being Moderated
    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.
    MacBook Pro, Mac OS X (10.4.10), iPhone 8GB
  • WWJD Level 6 Level 6 (15,815 points)
    Currently Being Moderated
    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:
    Photobucket

    Pages Paste Page 1 (Tables not grouped as in Numbers):
    Photobucket

    Pages Paste Page 2 (Charts & Graphic Object Paste true):
    Photobucket

    Regards,
    MDD Dual 1GHz 2GB RAM / QS 867MHz 1.5GB RAM, Mac OS X (10.5.2), 2930 SCSI / 16x DVR-110D / Yamaha 01X / 1GB Shuffle x 2 / 4GB Nano :o)
  • JanM Level 1 Level 1 (0 points)
    Currently Being Moderated
    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.
    MacBook Pro, Mac OS X (10.4.10), iPhone 8GB
  • JanM Level 1 Level 1 (0 points)
    Currently Being Moderated
    Feb 21, 2008 3:59 PM (in response to JanM)
    I found a different work-around. Export the Numbers sheet as PDF and then insert as "picture" in the Pages document. That worked.
    MacBook Pro, Mac OS X (10.4.10), iPhone 8GB
  • WWJD Level 6 Level 6 (15,815 points)
    Currently Being Moderated
    Feb 21, 2008 4:25 PM (in response to JanM)
    Yes, that is a good work-around if the quality of the pdf file is high enough for your situation.

    Regards,
    MDD Dual 1GHz 2GB RAM / QS 867MHz 1.5GB RAM, Mac OS X (10.5.2), 2930 SCSI / 16x DVR-110D / Yamaha 01X / 1GB Shuffle x 2 / 4GB Nano :o)

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.