Skip navigation

Print Numbers spreadseet text only

344 Views 8 Replies Latest reply: Oct 24, 2012 10:01 PM by aunkb RSS
aunkb Level 1 Level 1 (0 points)
Currently Being Moderated
Oct 23, 2012 3:34 PM

How can I print just the text of a numbers spreadsheet (while keeping all the pretty formatting styles seen on the screen)?

Thank you.


MacBook Air (13-inch Late 2010), OS X Mountain Lion (10.8.2)
  • Wayne Contello Level 6 Level 6 (12,580 points)
    Currently Being Moderated
    Oct 23, 2012 5:26 PM (in response to aunkb)

    You can print using the menu item "File > Print…"

  • Wayne Contello Level 6 Level 6 (12,580 points)
    Currently Being Moderated
    Oct 23, 2012 6:21 PM (in response to aunkb)

    make another table in another sheet that references the formatted table but does not contain any fancy formatting... maybe call the sheet "Print"

  • Wayne Contello Level 6 Level 6 (12,580 points)
    Currently Being Moderated
    Oct 24, 2012 6:16 PM (in response to aunkb)

    to make a table that referes to another,

     

    1) click on a cell in the "new" table.

    2) type "=", then click the cell in the original table you want it to refer to

    3) hit return to exist cell edit mode

     

    If you simply want to refer to every cell in a table, then select the top-left cell in "new" or destination table, type "=", then click in the corresponding cell in the original table.

     

    Now select the top-left cell, then grab (click and hold) the little circle then drag to the right to fill the references

     

    Now select the cells you just filled as a group and grab the circle at the bottom right of the selection, then drag down to fill as needed

  • Jerrold Green1 Level 7 Level 7 (28,135 points)
    Currently Being Moderated
    Oct 24, 2012 6:54 PM (in response to aunkb)

    I suggest that you Copy the Table with all the fancy formatting and then eliminate the formatting on the copy for printing purposes. For further use of the table you made for printing you may Copy, then Paste and Match Style into the unformatted table.

     

    Jerry

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.