How do you insert page breaks in a Numbers '09 spreadsheet?

You don't need page breaks. Enable Print View by selecting the menu item "View > Show Print View", then move, and scale the content to fit. to move, select objects and arrange as needed. To scale use the slider at to the bottom of the window where is says "Content Scale" (which is only visible in Print View Mode).

Numbers breaks to the next page when it reaches the bottom margin. Period. Table Rows that would otherwise touch the margin will be promoted to the next page.

A way to overcome the natural order is to Split a table at the point where you want to artificially cause a break and move the lower table segment to the next page. Another way is to increase your row heights to force rows lower on the page.

In "Print View", you can always tell which page your content will be on.

It's a big deal in Excel because you can't divide your Sheet into multiple "sub-tables" as you can in Numbers. Numbers lacks a Page Break code, but has other ways to control placement.

Jerry

Big Dog,

Numbers does NOT have page breaks. Can you post a screenshot of what you are looking at? Hard to help without information.

Well, Mr. Murphy, I didn't write Numbers, I'm just reporting how it works. We're just users like you.

Why not put each set into a separate table? Tables in Numbers are analogous to Named Ranges in Excel Worksheets.

Jerry

Here I placed several pages of music on the canvas while in Print View Mode and scaled and positioned the music on each page:

Yes, there is a solution. In your screen shot you have the top 16 rows selected, Grab them by the Tabs and pull them out of the main table and drop them as a new separate table on the canvas.

Move the lower part of the table to the next page of the Sheet and repeat the process until you have all the groups in separate tables, on separate pages.

If you are unwilling to accept any Numbers solution, then your only option is to go back to Excel.

Jerry

I hope you have success with this. Please report back.

Jerry

Dog,

Can you explain why the songs are grouped the way they are? If there is a rhyme or reason to this there may be a simple solution to breaking up the songs into pages.

Wayne,

I imagine that the set list involves an artistic sense of what the audience should hear and in what order. The beginning of each new set is identified by a 1 in column A.😉

Jerry

So if there were an extra, perhaps hidden, column you could increment each time you found a "1" in column A and that would be an indicator of which page to be in the printed version of the list. Then another, hidden, column which combines the song and page so they can be a lookup key. the print table would be set to the header row plus 16 rows are stretched to fit one page then expanded to as many pages as needed:

I am including the non-print list and the print list in the same sheet for brevity here.

For the both tables... the first row is a header.

For the table "Non-Print":

column A is used as the song number (you manually enter this).

B2=IF(A2=1, MAX($B$1:B1)+1, B1)

C2=A2&"_"&B2

select B2 and C2, copy

now select columns B and C, then command click on the B1 and C1 to unselect those two cells, paste

For the table "Print":

A2=1+MOD(ROW()-2, 16)

B2=INT(1+(ROW()-2)/16)

C2=IFERROR(VLOOKUP($A2&"_"&$B2, 'Non-Print' :: $C:$E, 2, 0), "")

D2=IFERROR(VLOOKUP($A2&"_"&$B2, 'Non-Print' :: $C:$E, 3, 0), "")

select A2 thru D2, copy,

now select columns A thru D, then command click cells A1, B1, C1, and D1 to unselect those cells, paste