7 Replies Latest reply: Jan 31, 2013 9:43 PM by Macfaz
hotwheels 22 Level 1 Level 1 (0 points)
I'm trying to find the thread where a couple of people have been helping me with this and at the risk of infuriating Yvan (sorry...) I am hoping to post again on this.

I am pulling down to "Paper Handling" and selecting "Scale to Fit Paper Size" (seems pretty straighforward...) but Numbers is still printing this spreadsheet on six **** pages. I printed to pdf and it does the same. This is getting infuriating. I need to take some documents with me when I travel this weekend.

Would anyone mind walking me through how I 'manually' put information on separate pages in Numbers of how I insert a page break or whatever it is that I have to do to get my information to print out on a couple of 8 1/2 x 11 pages? Having the information on six pages is really useless to me.

I'll study the documentation on my end in the meantime.

Thanks for any help.

macbookpro and macpro, Mac OS X (10.6.6), parallels VM
  • 1. Re: cripes. fit to page
    Barry Level 7 Level 7 (29,180 points)
    hotwheels #22 wrote:
    I am pulling down to "Paper Handling" and selecting "Scale to Fit Paper Size" (seems pretty straighforward...)

    It is pretty straightforward. Scale to fit "paper size" does not mean scale to fit on a "single page". It means "resize this document so that one page of the document fits on one page of the size of paper I wish to print it on." This option in the Print dialogue is used when someone sends you a document laid out on an A4 page size, for example. If you Scale to fit paper size and choose US Letter, the content of the document will be scaled to fit one A4 page onto one US Letter page.

    Would anyone mind walking me through how I 'manually' put information on separate pages in Numbers of how I insert a page break or whatever it is that I have to do to get my information to print out on a couple of 8 1/2 x 11 pages?


    Numbers does not support the insertion of Page Breaks.
    You can force two tables, which together would fit onto a single page, to print on separate pages by placing then on separate sheets. Each sheet will print as at least one page (but may print as more than one page, depending on content).

    You can reduce the number of pages by:

    Removing content.
    Re-scaling the content using the Content Scale slider seen at the bottom of the window when Print View is shown.
    Setting Layout in the Print dialogue to print 2, 4, 6, 9 or 16 pages on one page.

    Regards,
    Barry
  • 2. Re: cripes. fit to page
    Jerrold Green1 Level 7 Level 7 (28,995 points)
    HW22,

    In addition to what Barry said, many new users need to be reminded that if you have blank columns and rows on your sheet, they are considered content. Numbers assumes that if you have a table, you want to print the entire table, blank cells and non-blank ones. In Excel there is an assumption that you don't want to print the millions of empty cells on the typical sheet. That's why in Excel you really need a Print Area command. In Numbers you don't need it. Your content determines what gets printed, and where.

    So, if you have blank rows and columns that are causing extra pages to be printed, delete them before trying to print.

    Jerry
  • 3. Re: cripes. fit to page
    MattRA Level 1 Level 1 (5 points)

    PRINTING IN NUMBERS

     

    • Numbers lacks the 'Set print area' command and the work around isn't that flash.

     

    Option One:

    * make sure you're not in Print View - check the 'View' menu.

     

    1. select the cells you wish to print

    2. Choose 'Copy' from the 'Edit" menu

    3. Click the 'Sheet' icon (top left corner of window, just below the red/orange/green buttons.

    4. Choose 'Paste' from the "Edit" menu

    5. Use the grey corner (at the bottom right corner of the pasted data) to resize the table - removing any unneeded columns/rows. The grey corner is highlighted in the sheet below. In this example, I'd remove column E as it contains no data.

     

    grey corner.png

     

    6. Choose "Print" from the "Edit" menu.

     

    Option Two:

     

    1. Choose "Show Print View" from the "Edit" menu

    2. Use the "Content Scale" slider at the bottom of the window, to scale the content so that it fills the page.

    3. Choose "Print" from the "Edit" menu.

     

    See examples below - see how sliding the scaler to 150% makes the content fill the page - but there are still empty columns (F&G) that can't be scaled away as doing so forces the data in the bottom rows, off the page. Hence, I think Option One is the better method.

     

     

     

    scaled to 150.png

     

  • 4. Re: cripes. fit to page
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    Hi Matt,

     

    Here's what I believe to be the most compact set of instructions for printing a segment of a table, filling a printed page:

     

    1. Select area of Table to be printed.
    2. Command-C
    3. Switch to Preview.app
    4. Command-N
    5. Command-P
    6. Select the Scale to Fit option in the Print Dialog
    7. Change the Portrait/Landscape selection if you wish
    8. Click Print.

     

    Jerry

  • 5. Re: cripes. fit to page
    MattRA Level 1 Level 1 (5 points)

    Hi Jerry

     

    That's an even better solution. I posted my two solutions as hadn't found a documented useful solution, and there appeared to be lots of people with the issue. Plenty of people willing to bag Numbers, and compare it to Excel, but no solutions...

     

    Matthew

  • 6. Re: cripes. fit to page
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    Matthew,

     

    Change can be difficult and anyone coming to iWork thinking it's equal to Office but better since it's by Apple may be disappointed by the differences in the interface. Many of the differences aren't deficiencies. I think this Print Area thing is just a matter of habit, for instance. If you take the case where the area you want to print right now is different from the area you printed an hour ago and compare the number of keystrokes in Excel vs. Numbers, you won't find much difference, and Numbers offers much more flexibility in how it may be done.

     

    Jerry

  • 7. Re: cripes. fit to page
    Macfaz Level 1 Level 1 (0 points)

    Hi MattRA,

     

    Just wanted to say Thank You as the 2nd option of your proposed solution worked like to magic to me exactly as I wanted it :-)

     

    Fawaz.