3 Replies Latest reply: Oct 10, 2011 1:13 PM by Jerrold Green1 Branched to a new discussion.
rafcior Level 1 Level 1 (0 points)

I am interested in printing only one table from a spreadsheet with multiple tables.  In Excel, it would be to set a "Print Area".  I'd expect to select the table or tables and be able to do this.  Surely it's possible?


Numbers
  • 1. Re: What is the Number's equivalent of Excel's "Set Print Area"?
    Wayne Contello Level 6 Level 6 (13,615 points)

    There is no "Set Print Area".  Here are some ways to get what you want:

     

    1) you can enable Print view to see how the document will print

    (use the menu item "View > Show Print View")

    Screen shot 2011-10-10 at 12.48.23 PM.png

     

    2) you can drag tables around so they are placed propoerly on the pages

     

     

    3) you can scale to fit

    (use the slide at the bottom of the Numbers window)

    Screen shot 2011-10-10 at 12.50.27 PM.png

     

    4) you can select which pages to print in the print dialog box

    Screen shot 2011-10-10 at 12.51.08 PM.png

  • 2. Re: What is the Number's equivalent of Excel's "Set Print Area"?
    rafcior Level 1 Level 1 (0 points)

    Thank you!  Most kind of you to include visuals!  Cheers.

  • 3. Re: What is the Number's equivalent of Excel's "Set Print Area"?
    Jerrold Green1 Level 7 Level 7 (28,990 points)

    rafcior wrote:

     

    I am interested in printing only one table from a spreadsheet with multiple tables.  In Excel, it would be to set a "Print Area".  I'd expect to select the table or tables and be able to do this.  Surely it's possible?

    You bring up a topic that's curious to me. Many formar Excel users become upset when they can't find "Set Print Area" in Numbers and to my way of thinking, that feature in Excel is quite a crude way to print a portion of a table or sheet compared to what can be done in Numbers.

     

    I think that the best approach is to think ahead and anticipate what data will need to be printed separately and provide for that from the beginning as the document is designed.

     

    It's easy to organize your layout so that tables and groups of tables are organized on separate Pages in Print View. Then, in the Print dialog, choose to print only the pages you desire. Then on these separate pages you can add graphics and text box annotations, etc., far beyound what could have been done in Excel.

     

    For those who only want the very basic ability that Excel offers, to print a block of cells from the interior of a larger table, I recommend this:

     

    • Select the cell range
    • Command-C
    • Switch to Preview.app
    • Command-N
    • Command-P

     

    Best regards,

     

    Jerry