Jankellis

Q: how to print selected cells in numbers

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)

Posted on Jan 13, 2013 7:58 AM

Close

Q: how to print selected cells in numbers

  • All replies
  • Helpful answers

Page 1 of 3 last Next
  • by Jerrold Green1,Apple recommended

    Jerrold Green1 Jerrold Green1 Jan 13, 2013 8:32 AM in response to Jankellis
    Level 7 (30,001 points)
    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

  • by vjdjr,Apple recommended

    vjdjr vjdjr Jan 13, 2013 9:21 AM in response to Jankellis
    Level 2 (192 points)
    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

  • by Barry,

    Barry Barry Jan 13, 2013 11:00 AM in response to vjdjr
    Level 7 (32,537 points)
    iWork
    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

  • by nmygs,

    nmygs nmygs Jan 19, 2014 10:48 AM in response to Jankellis
    Level 1 (0 points)
    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!

  • by LifeboatParty,

    LifeboatParty LifeboatParty Jun 5, 2014 7:30 PM in response to nmygs
    Level 1 (20 points)
    iPad
    Jun 5, 2014 7:30 PM in response to nmygs

    I know, right? In Windows, you can simply choose "print selection." But what else is new? Working on Apple software always requires six fingers, a third-party hack, and about triple the steps of working in Windows.

  • by Yellowbox,

    Yellowbox Yellowbox Jun 6, 2014 4:34 AM in response to LifeboatParty
    Level 6 (10,515 points)
    Mac OS X
    Jun 6, 2014 4:34 AM in response to LifeboatParty

    Numbers does not have Print Selection or Set Print Area because it does not need them. Numbers uses several discrete tables, each with a purpose. The Fruit table pulls values from the Very Big Data Table to produce a Presentation for printing. Similarly, a Vegetables table could the same, and so could any Department.

     

    Screen Shot 2014-06-06 at 9.20.23 pm.png

     

    Each Presentation table can be on its own sheet. Formulas will link between sheets.

     

    Choose a sheet

    Command p (to see Print Preview)

    Click on Current Sheet or This Sheet (depending upon which version of Numbers).

    Confirm your intention to print.

    Done.

     

    Regards,

    Ian.

  • by nmygs,

    nmygs nmygs Jun 6, 2014 5:14 AM in response to Yellowbox
    Level 1 (0 points)
    Jun 6, 2014 5:14 AM in response to Yellowbox

    Thank you for your suggestion, however, that isn't the same as the very-easy-to-use Print Selection feature in Microsoft Excel.

  • by Yellowbox,

    Yellowbox Yellowbox Jun 6, 2014 7:17 AM in response to nmygs
    Level 6 (10,515 points)
    Mac OS X
    Jun 6, 2014 7:17 AM in response to nmygs

    Hi nmygs,

     

    How about this?

     

    Screen Shot 2014-06-07 at 12.05.34 am.png

     

    Cell A1 is a Pop-Up Menu containing names of the various "Departments"

     

    Screen Shot 2014-06-07 at 12.07.33 am.png

     

    Screen Shot 2014-06-07 at 12.15.36 am.png

     

    Other cells contain formulas to find a match for whatever is chosen in A1 from the Very Big Data Table.

     

    Reusable Print Me table.

     

    Regards,

    Ian.

  • by applenascent,

    applenascent applenascent Jun 12, 2014 6:17 PM in response to nmygs
    Level 1 (0 points)
    Jun 12, 2014 6:17 PM in response to nmygs

    My thoughts exactly.  This is an abomination.  I thought I was just missing something obvious a la "set selected area for print" buried under some menu or cmd-key sequence.  Surely there's another way.  It's 2014 -- not 1984.

  • by SGIII,

    SGIII SGIII Jun 12, 2014 6:31 PM in response to applenascent
    Level 6 (10,760 points)
    Mac OS X
    Jun 12, 2014 6:31 PM in response to applenascent

    Surely there's another way.  It's 2014 -- not 1984.

     

    There may be some users that aren't quite as dependent on old-fashioned printouts in 2014 as in 1984.  And when you do need to print out part of a document, Jerry's and Ian's suggestions do the job without much trouble.

     

    However, if you feel strongly that you often need to print just parts of a document (and you don't want to redesign your document) then in your menu choose Numbers > Provide Numbers Feedback.  We're just fellow users here.

     

    SG

  • by Wayne Contello,

    Wayne Contello Wayne Contello Jun 12, 2014 6:39 PM in response to applenascent
    Level 6 (19,312 points)
    iWork
    Jun 12, 2014 6:39 PM in response to applenascent

    select the cells, copy,

    open Preview

    select the menu item "File > New From Clipboard"

    print

  • by SGIII,

    SGIII SGIII Jun 12, 2014 6:54 PM in response to Wayne Contello
    Level 6 (10,760 points)
    Mac OS X
    Jun 12, 2014 6:54 PM in response to Wayne Contello

    Hey, Wayne, could you explain how your method differs from Jerry's upthread? (The first reply to OP).

     

    SG

  • by chris Cairns,

    chris Cairns chris Cairns Jun 26, 2014 8:17 PM in response to Jerrold Green1
    Level 1 (5 points)
    Jun 26, 2014 8:17 PM in response to Jerrold Green1

    Thanks for the reply. Why does it copy Table Name? How to avoid it?

  • by Yellowbox,

    Yellowbox Yellowbox Jun 26, 2014 8:46 PM in response to chris Cairns
    Level 6 (10,515 points)
    Mac OS X
    Jun 26, 2014 8:46 PM in response to chris Cairns

    Hi Chris,

     

    Hide the table name in Format Panel > Table > Untick Table Name

     

    Screen Shot 2014-06-27 at 1.44.29 pm.png

Page 1 of 3 last Next