Large spreadsheet, want to insert page breaks and print into 126 pages breaking by sales persons name, versus the 33 pages it naturally breaks at, did in excel all the time. How to do this in pages?
MacBook Air, macOS Sierra (10.12.6)
Hi Lorena,
Numbers has a different design approach from Excel.
Numbers uses several tables, each with a purpose.
The Very Large Table is the database. Only a few rows shown in this screen shot.
No need to select print areas.
Summary tables can "pull" relevant data from the database
This Summary table uses the SUMIF function
Formula in B2 of the Summary (and Fill Right and Fill Down)
=SUMIF(Very large table::$A,$A2,Very large table::B)
When the formula is working to your satisfaction, Select the Summary table (click on the "bullseye") and Menu > Edit > Cut.
That will place it on the Clipboard.
Insert a new Sheet (Tab) and delete the default table.
Paste.
Numbers will automatically adjust formulas (if necessary).
Print Preview
One page 😉.
Regards,
Ian.
Hi Lorena,
Numbers has a different design approach from Excel.
Numbers uses several tables, each with a purpose.
The Very Large Table is the database. Only a few rows shown in this screen shot.
No need to select print areas.
Summary tables can "pull" relevant data from the database
This Summary table uses the SUMIF function
Formula in B2 of the Summary (and Fill Right and Fill Down)
=SUMIF(Very large table::$A,$A2,Very large table::B)
When the formula is working to your satisfaction, Select the Summary table (click on the "bullseye") and Menu > Edit > Cut.
That will place it on the Clipboard.
Insert a new Sheet (Tab) and delete the default table.
Paste.
Numbers will automatically adjust formulas (if necessary).
Print Preview
One page 😉.
Regards,
Ian.
numbers does not have the same type of thing like a page break preview you might have been used to on Excel. there is no way to force page breaks based on rows or any other criteria in a single table.
Excel is made up tabs, each one a large sheet of rows and columns so it makes sense to be able to break at certain row counts per tab. There is only one "table" to work with at a time.
In Numbers there could be a dozen or more individual tables on a working sheet. Each can be located anywhere, including overlapping each other. so breaking at rows on one table will break at a different location on others. Its just a different design philosophy.
Jason
Unfortunately, the only way to do this is by...
Check out the print preview window to see how many rows will be printed. Then add enough blank rows to make one page on your printer. Outline the area to make it easy to see just how many rows you have left for each page. Then outline the same number of rows or just keep it in your head how many rows make up a page. If it's an odd number, just vary the height of the rows to make something easy to remember. 47 rows would be hard to keep track of, but not 50.
do you have any experience with Applescript? You could use it to break the table into 126 tabs that could be printed or worked with.
You could make a series of them to manage the tabs.
Jason
I should have known you would know the answer to this, Ian.
Thanks for this!
Hi Pete,
Thank you. Keep up the good work, and keep posting in Numbers for Mac. You will soon be on Level 2.
Regards,
Ian
how to insert page breaks into a numbers spreadsheet?
