5 Replies Latest reply: Oct 26, 2013 1:30 PM by douglasfromnewton
peterfromcable bay Level 1 Level 1 (0 points)

I am familiar with Appleworks and Clarisworks spreadsheets, where one can select a part of a spreadsheet by setting printrange, and only printing the selected part, which I find useful.  But how do I do that or similar in Numbers?  It seems that if my spreadsheet in Numbers is divided into sheets, I have to print at least a complete sheet and it is not possible to print just part of a spreadsheet.  Or is it possible? Help and advice please!

Peter


iMac, Mac OS X (10.5.8)
  • 1. Re: how to set a print range
    Barry Level 7 Level 7 (29,180 points)

    Several ways:

     

    Go View > Show Print view, so that you can see what will appear on each page.

     

    • Set Content scaling using the slider at the bottom of the window so that the area you want to print fills the page.
    • Select, then Copy the group of cells you want to print, open Preview, then press command-N or go File > New from clipboard. Print.
    • Select, then Copy the group of cells you want to print, Add a new Sheet to your document. Delete the default Table that comes with the new sheet. Paste. Your selection will appear on the sheet as a new table. Position and sizeas you wish. Print the sheet.
    • If you are going to print the same set of cells on several occasions, create a table to copy the content of that set. Move the Table to a separate Sheet, where it will continually update. To print, switch to the sheet containing the table. Print.

     

    Regards,

    Barry

  • 2. Re: how to set a print range
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    Peter,

     

    Barry gave you a very nice review of your options. A couple of comments.

     

    I think the sweet spot for maximum benefit vs. effort is Barry's third option - adding a dedicated Sheet for printing a pasted range of cells. This way you have complete and easy control over size and placement of the cells on the printed page, and you can add titles, comments and formatting. I would only add that if there are equations in the copied range that reference cells outside of the selection, it's best to Edit > Paste Values, rather than to do a straight Paste.

     

    If you were a former Excel user complaining about the lack of "Define Print Range" feature, I'd recommend the second option, even though I'd seldom use it myself.

     

    Regards,

     

    Jerry

  • 3. Re: how to set a print range
    peterfromcable bay Level 1 Level 1 (0 points)

    Thank you both Barry and Jerry. Your replies give workable solutions which are fine.  Thank you with speed of reply too... I am impressed!

     

    However, I don't think any of the suggested methods are as elegant a way of doing things as selecting printrange in Appleworks. Who knows.... Apple may add that feature to Numbers in due course? Here's hoping!

     

    Peter (in New Zealand).

  • 4. Re: how to set a print range
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    Peter,

     

    I missed Select Print Range myself when I first made the conversion to Numbers from Excel. I submitted Feedback to Apple. I thought it was a big deal then. Now that I'm comfortable with Numbers I no longer feel that way. I can Select a range, Command-C, Command-Tab to Preview, Command-N, Command-P faster than I ever could setup and print a range in Excel, so I don't miss it at all. Let us know how you feel in six months .

     

    Jerry

  • 5. Re: how to set a print range
    douglasfromnewton Level 1 Level 1 (0 points)

    Thank you all for your work arounds but I agree all are inelegant (to the say the least). Imoften need to print a portion of a single page and would like a simple way to do so as in other spread sheets.

     

    Doug (eager to use only 1 spreadsheet program, preferably from Apple)