Skip navigation

"Page Breaks" in Numbers

2873 Views 7 Replies Latest reply: Jan 20, 2013 6:55 AM by WyattHMNYC RSS
jschaub Calculating status...
Currently Being Moderated
Oct 8, 2012 10:46 AM

I have a spreadsheet that I need to break apart into separate pages, each with the same header. AppleWorks used to have a Page Break function - How is that done with Numbers?

iMac, Mac OS X (10.7.4)
  • Wayne Contello Level 6 Level 6 (12,625 points)
    Currently Being Moderated
    Oct 8, 2012 11:07 AM (in response to jschaub)

    set the header by selecting the first row of your table, then use the contextual menu for that row to set it as a header:


    Screen Shot 2012-10-08 at 1.04.24 PM.png


    Now enable print view for the sheet by selecting the menu item "View > Show Print View":

    Screen Shot 2012-10-08 at 1.05.47 PM.png


    expand the table so it spans more than one page if you need more than one page

  • Jerrold Green1 Level 7 Level 7 (28,175 points)
    Currently Being Moderated
    Oct 8, 2012 12:21 PM (in response to jschaub)



    Numbers doesn't have a Page Break command or feature. It's a What You See is What You Get program, and if you want some content to move to another page you have to adjust the content manually until it looks the way you want it to. An easy way is to grab the Row Height control of the last row you wish to display on the current page and drag it down until all rows below have jumped off that page. Or, you could split the table into separate smaller tables by dragging them into pieces – a more laborious option.



  • iosiP Calculating status...
    Currently Being Moderated
    Nov 17, 2012 8:57 AM (in response to Jerrold Green1)

    I have the same problem but your solution doesn't work for me: I need the page breaks to stay put even if I insert/delete rows (it's a table holding items in alphabetical order so it should break at each new letter).


    My solution: I export the table in Excel and transfer it to my laptop. Not funny.. so I might as well get Office for Mac.



  • Jerrold Green1 Level 7 Level 7 (28,175 points)
    Currently Being Moderated
    Nov 17, 2012 5:11 PM (in response to iosiP)



    If you want a break after each change in the first character position, you will have to use separate tables for each possible first letter, leaving room for expansion as you add rows. I know it's not a particularly clean solution but a more automated way would involve much more complication in the programming of the document.



  • iosiP Level 1 Level 1 (0 points)
    Currently Being Moderated
    Nov 18, 2012 3:46 AM (in response to Jerrold Green1)

    Thanks, Jerry,


    But there is no way I can use your solution now.

    The spreadsheet holds my music collections (around 2,500 CDs), split into 15 genres. So I already have 15 worksheets @ 1 table each (actually 16 if you count the Summary). Splitting each and every table in 26 separate tables would be a killer job that I am not willing to do.


    I still think paying $119 for Office for Mac would be much easier...




    P.S. OTOH, I prefer using Pages instead of Word so it looks like there is no perfect software world out there!


    Message was edited by: iosiP

  • Jerrold Green1 Level 7 Level 7 (28,175 points)
    Currently Being Moderated
    Nov 18, 2012 10:19 AM (in response to iosiP)



    You are working in Database app territory.



  • WyattHMNYC Calculating status...
    Currently Being Moderated
    Jan 20, 2013 6:55 AM (in response to jschaub)

    This isn't the 'ideal solution', but has the same desired effect.


    Save a 'master' version of the Worksheet.


    Create two duplicates of the table in the Worksheet. 


    Then delete the columns you don't want/need from the first table and the duplicate table.


    Move tables onto their own sheet of paper.


    Repeat with the original table as often as you need.


    Save 'print' version of the Worksheet.


    Not automatic if you changes, but seriously, who prints stuff out that often anymore?


More Like This

  • Retrieving data ...

Bookmarked By (0)


  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.