Skip navigation

how to print selected cells in numbers

1895 Views 4 Replies Latest reply: Jan 19, 2014 10:48 AM by nmygs RSS
Jankellis Calculating status...
Currently Being Moderated
Jan 13, 2013 7:58 AM

Does anyone know how to print selected cells in a Numbers spreadsheet, rather than printing the entire sheet?

 

Also, how to save the selected cells as a pdf file without saving the irrelevant cells?

MacBook Pro (13-inch, Mid 2012)
  • Jerrold Green1 Level 7 Level 7 (28,190 points)
    Currently Being Moderated
    Jan 13, 2013 8:32 AM (in response to Jankellis)

    Jan,

     

    The two questions use the same basic answer. In OS X, printing an Object Selection is easily handled in Preview.app, and the native file type there is PDF.

     

    Here's the procedure:

     

    Select the cell range in Numbers and Command-C to copy it to the Clipboard

     

    Launch or switch to Preview.app

     

    Command-N to create a PDF file from the Clipboard content

     

    Command-P to Print

     

    Command-S to save the PDF file

     

    Regards,

     

    Jerry

  • vjdjr Level 2 Level 2 (175 points)
    Currently Being Moderated
    Jan 13, 2013 9:21 AM (in response to Jankellis)

    There's another answer, though Jerry's works just fine.  I'm just offering a different way to look at the problem.

     

    If the cells you're selecting are complete row(s), you can use the "Show" feature to limit what rows are seen on screen ... then just a regular print or save-as-pdf in the print dialog box will work.

     

    Hover on the letter indicator of any column (A, B, etc.), and click on the small triangle that's on the right.  Click on "Show More Options" and the 2nd option is "Show rows that match the following".  Set up whatever criteria you need.  Click the box and =presto= the other rows disappear.  They're still there, usable for any calcuations, but unseen.

     

    You can also "unsee" any specific columns you dont' want visable.  Again, just hover over the column letter and click on the triangle.  "Hide this column" will do the trick.

     

    Vince

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Jan 13, 2013 11:00 AM (in response to vjdjr)

    Vince wrote:

    "You can also "unsee" any specific columns you dont' want visable.  Again, just hover over the column letter and click on the triangle.  "Hide this column" will do the trick."

     

    Also applies to several adjoining columns (or adjoining rows). Select the columns, reveal the triangle on one of them, and select Hide Columns from the pop-up menu.

    Picture 14.png

    Regards,

    Barry

  • nmygs Calculating status...
    Currently Being Moderated
    Jan 19, 2014 10:48 AM (in response to Jankellis)

    You have got to be kidding me? This is how Numbers prints a selection? Unbelievable!

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.