keithred
Level 1 (9 points)
iWork

Q: how to copy a list from numbers to pages without grid

Is there any way to copy a list from numbers to a pages file without the grid?

Mac mini, OS X Yosemite (10.10.1)

Posted on Jul 14, 2016 12:53 AM

Close
keithred

Q: how to copy a list from numbers to pages without grid

  • All replies
  • Helpful answers

  • by Barry,

    Barry Barry Jul 14, 2016 1:42 AM in response to keithred
    Level 7 (32,271 points)
    Jul 14, 2016 1:42 AM in response to keithred

    Hi Keith,

     

    In Pages '09, this is an easy task:

    1. Select  all cells of the table in Numbers. Copy
    2. Click on the page in a Pages word processing document. Paste.
    3. Click on the resulting table to select it.
    4. Go Format > Table >Convert Table to Text

    Screen Shot 2016-07-14 at 1.19.22 AM.png

     

    Result:

    Screen Shot 2016-07-14 at 1.20.19 AM.png

    With Pages 5, though, the two Convert menu items are missing. Here, I called on Text Edit to serve as an intermediary.

    1. Copy, as before.
    2. Open Text Edit, then go Edit > Paste and Match Style.
      Screen Shot 2016-07-14 at 1.22.54 AM.png
    3. Select the block of text, and again, Copy.
    4. Go to Pages, click on the page, then go Edit > Paste and match style…for this result:
      Screen Shot 2016-07-14 at 1.23.14 AM.png
    5. Select from somewhere in the top row to somewhere in the bottom row, then adjust the tab stops to fit the tabs in the pasted text.

    Regards,

    Barry

  • by Yellowbox,

    Yellowbox Yellowbox Jul 14, 2016 7:09 AM in response to keithred
    Level 6 (10,430 points)
    Mac OS X
    Jul 14, 2016 7:09 AM in response to keithred

    Hi Keith,

     

    Adding to Barry's reply, see this User Tip by VikingOSX

    Pages v5: Same document: table to text/text to table.

     

    Regards,

    Ian.

  • by VikingOSX,

    VikingOSX VikingOSX Jul 15, 2016 4:40 AM in response to keithred
    Level 7 (20,544 points)
    Mac OS X
    Jul 15, 2016 4:40 AM in response to keithred

    Going from Numbers '09 2.3 to Pages '09 v4.3, you can just select, copy, and paste the Numbers table content into Pages '09. You then visit the Table Inspector, and with your table selected in Pages '09, you set your cell borders to None in its selector. Click the following to enlarge.

     

         Numbers '09 v2.3                                   Pages '09 v4.3

    Screen Shot 2016-07-15 at 7.09.07 AM.jpgScreen Shot 2016-07-15 at 7.08.34 AM.jpgScreen Shot 2016-07-15 at 7.08.04 AM.jpg

     

    From Numbers v3.6.2 to Pages v5.6.2 on OS X 10.11.5

     

    Again, select, copy, and paste the Numbers data and just paste into Pages. With the table selected in Pages, click the Table tab on the right panel. Set the Table outline to None. Deselect the left three Gridlines buttons. If you don't want a table name, you can select that in this panel too. Next, in the Cell tab, set Border Styles to None. If you don't want the fill, you can turn that off in the Cell tab's Fill section.

     

    You can turn off grid and fill in Numbers v3.6.2 on the Table and Cell tabs, just as in Pages v5.6.2 — before you copy/paste it too.

     

         Numbers v3.6.2                                                                 Pages v5.6.2

    Screen Shot 2016-07-15 at 7.25.17 AM.jpgScreen Shot 2016-07-15 at 7.27.32 AM.jpg

    Screen Shot 2016-07-15 at 7.31.56 AM.jpgScreen Shot 2016-07-15 at 7.32.25 AM.jpg

     

    And, as Yellowbox graciously posted, there is my user tip: Pages v5: Same document: table to text/text to table.