3 Replies Latest reply: Aug 9, 2014 11:39 PM by Yellowbox
CAM2009 Level 1 Level 1

I need Numbers to create a PDF spreadsheet that has actual page breaks instead of one long table.  Why can't I do this??  I frequently need to share spreadsheets with those not using a Mac or any spreadsheet software at all.  But when I export my two page spreadsheet to a PDF, the file is just a long table without breaking it up into two pages.  Perhaps someone could print it and stretch it out over two pages, but I should be able to format how something should look as a PDF and there doesn't seem to be any way to do that.  When I try to insert a page break, the option is grayed out.  Any help would be appreciated.

  • Wayne Contello Level 6 Level 6

    you can only see pagination in Numbers 3.2 when you select the menu item "File > Print...".  This is departure from the way Apple designed Number '09.


    You can provide feedback using the menu item "Number > Provide Number Feedback"


    Ian has written a user tip:

    Print Layout Guide for Numbers 3 on Mac

  • CAM2009 Level 1 Level 1

    Thanks, Wayne.  I cannot figure out why Apple would remove such an elementary tool - I simply figured I couldn't find how to do it, not that it didn't really exist any more . 

  • Yellowbox Level 6 Level 6
    Mac OS X

    Hi Cam,


    Instead of Menu > File > Export To... > PDF, do

    Menu > File > Print... to get Print Preview.


    A large table in Print View (zoomed out for a smaller screen shot)

    The page breaks are inserted.

    Screen Shot 2014-08-10 at 4.17.38 pm.png


    The Print Setup panel on the right allows you to set the page margins (drag the panel up to see).


    Screen Shot 2014-08-10 at 4.26.09 pm.png


    Now click on Print... to get the Print Dialogue


    Screen Shot 2014-08-10 at 4.29.26 pm.png


    Click on PDF (lower left)


    Screen Shot 2014-08-10 at 4.31.40 pm.png


    Save as PDF.

    Here is the PDF (zoomed out for a smaller screen shot)


    Screen Shot 2014-08-10 at 4.34.37 pm.png