David Rosen
Level 1 (36 points)

Q: How do you insert a page break in Numbers?

I'm considering switching from Excel to Numbers. I'm experimenting with some complex spreadsheets that I use, and Numbers '09 has removed my manual page breaks. How do you insert a page break in Numbers? Is it possible to do this in the 2011 version? I don't want to add mutliple new rows to accomplish it.

iMac, Mac OS X (10.6.8)

Posted on Nov 17, 2011 11:43 AM

Close
David Rosen

Q: How do you insert a page break in Numbers?

  • All replies
  • Helpful answers

Previous Page 2

  • by StratGirl,

    StratGirl StratGirl Jan 27, 2016 10:31 PM in response to Jerrold Green1
    Level 1 (0 points)
    Jan 27, 2016 10:31 PM in response to Jerrold Green1

    I did the blank row insert method; however, I'm still trying to figure out how to "delete" the borders. I've set up the borders so they aren't showing when looking at the spreadsheet, but when printed, a single line appears at the bottom of the page. I'll have to tinker with it a bit more, I guess. Your answer has been helpful. Thanks!

  • by Yellowbox,

    Yellowbox Yellowbox Jan 28, 2016 12:36 AM in response to StratGirl
    Level 6 (10,535 points)
    Mac OS X
    Jan 28, 2016 12:36 AM in response to StratGirl

    Hi StratGirl,

     

    I don't miss page breaks. Just let Numbers do the work for you.

    This table has a Header Row and a Header Column.

    For illustration only, I entered the formula =ROW() into Cell A2 and Filled Down.

    Screen Shot 2016-01-28 at 7.19.44 pm.png

    Menu > File > Print to see Print Setup.

    Screen Shot 2016-01-28 at 7.28.32 pm.png

    Tick Repeat Table Headers to get this in Print Preview:

    Screen Shot 2016-01-28 at 7.30.56 pm.png

     

    On the other hand, if you want to arrange objects (such as small tables, graphs, text boxes) within a page, have a look here:

    Print Layout Guide for Numbers 3 on Mac

     

    Regards,

    Ian.

Previous Page 2