Page Breaks for entire spreadsheet


D

Dave_in_NoHo

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?
 
Ad

Advertisements

J

John C

Are these manual page breaks? xl2003 has a limit on how many manual
pagebreaks you can have (1026).

If you fit exactly 10 rows per page, why do you need manual page breaks?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top