Previous 1 2 Next 16 Replies Latest reply: Jun 28, 2014 9:22 PM by applenascent
Jankellis Level 1 Level 1 (0 points)

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 (29,850 points)

    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 (185 points)

    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,205 points)

    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 Level 1 Level 1 (0 points)

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

  • LifeboatParty Level 1 Level 1 (5 points)

    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.

  • Yellowbox Level 5 Level 5 (6,180 points)

    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.

  • nmygs Level 1 Level 1 (0 points)

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

  • Yellowbox Level 5 Level 5 (6,180 points)

    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.

  • applenascent Level 1 Level 1 (0 points)

    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.

  • SGIII Level 5 Level 5 (5,245 points)

    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

  • Wayne Contello Level 6 Level 6 (14,895 points)

    select the cells, copy,

    open Preview

    select the menu item "File > New From Clipboard"

    print

  • SGIII Level 5 Level 5 (5,245 points)

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

     

    SG

  • chris Cairns Level 1 Level 1 (5 points)

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

  • Yellowbox Level 5 Level 5 (6,180 points)

    Hi Chris,

     

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

     

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

Previous 1 2 Next