Add Page break in Numbers
How can I add a page break in a Numbers Spreadsheet without adding a row at a time?
How can I add a page break in a Numbers Spreadsheet without adding a row at a time?
"Pages" in Numbers do not exist except when you are printing or preparing to print a Numbers document.
When you press command-P, Numbers displays the document as it will appear when printed. You cannot edit the document in this mode, but you can take notes on what needs to be changed to place the 'page breaks' where you need or want them.
For each 'page break' you will need to estimate the height of a new row to be inserted below the last row that you want to be shown on this page, and will be just tall enough to push the row below onto the next page and short enough that it does not itself jump to the next page.
Cells in this row will also need to be empty, and to either have their vertical (and perhaps bottom) borders set to none or coloured to match the page background.
If the table is too wide to fit on a single page, a similar adjustment will need to be made to the right of the last column you want to appear on the left 'page' when printed.
The process will need to be repeated for each new page needed.
Alternative: Use an application that does support Row breaks and Column breaks to set page breaks where you want them.
Examples include MS Excel and the free LibreOffice.
Regards,
Barry
Although you cannot edit the document in this view, you can make n
"Pages" in Numbers do not exist except when you are printing or preparing to print a Numbers document.
When you press command-P, Numbers displays the document as it will appear when printed. You cannot edit the document in this mode, but you can take notes on what needs to be changed to place the 'page breaks' where you need or want them.
For each 'page break' you will need to estimate the height of a new row to be inserted below the last row that you want to be shown on this page, and will be just tall enough to push the row below onto the next page and short enough that it does not itself jump to the next page.
Cells in this row will also need to be empty, and to either have their vertical (and perhaps bottom) borders set to none or coloured to match the page background.
If the table is too wide to fit on a single page, a similar adjustment will need to be made to the right of the last column you want to appear on the left 'page' when printed.
The process will need to be repeated for each new page needed.
Alternative: Use an application that does support Row breaks and Column breaks to set page breaks where you want them.
Examples include MS Excel and the free LibreOffice.
Regards,
Barry
Although you cannot edit the document in this view, you can make n
Just a thought, but if you have to print out an Numbers table that spans multiple pages and you need some control over how it splits across pages, then you can try copy-pasting it into Pages (click the table in Numbers, then the "bulls-eye" concentric circles to its upper left, command-c, click in an open document Pages and command-v to paste).
Then in Pages click 'Move with Text' under the Arrange tab in the inspector pane at the right and the table will split across pages, repeating the Header Row.
Insert Page Break won't work, but you can try adjusting the position of the footer, etc. (under the Document tab) to get the table to break where you want.
SG
Add Page break in Numbers