Page Breaks for entire spreadsheet
 

I have a very large spreadsheet (over 17,000 records) and I'm printing about
15 pages per day.
When I first made the spreadsheet, the header, footer, and margin settings
limited me to 9 rows per page. I changed the footer and margin settings and
now I can fit 10 rows per page. How do I make this change for the WHOLE
spreadsheet, so that from now on when I print pages there will be 10 rows per
page?

Page Breaks for entire spreadsheet
 

Hi
Will it work to highlight the area which you made fit and then press the
"formatbrush", and press the upper right corner of the sheet?
Good luck
Therese

"Dave_in_NoHo" wrote:

I have a very large spreadsheet (over 17,000 records) and I'm printing about
15 pages per day.
When I first made the spreadsheet, the header, footer, and margin settings
limited me to 9 rows per page. I changed the footer and margin settings and
now I can fit 10 rows per page. How do I make this change for the WHOLE
spreadsheet, so that from now on when I print pages there will be 10 rows per
page?