| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Page Breaks for entire spreadsheet
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? -- John C "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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Page Breaks for entire spreadsheet | Excel Discussion (Misc queries) | |||
| setting page breaks for whole spreadsheet to be consistent? | Setting up and Configuration of Excel | |||
| How to copy page breaks within an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
| Page Breaks for Entire Work Book | Excel Discussion (Misc queries) | |||
| How to add page breaks to embedded spreadsheet | Excel Worksheet Functions | |||
Linear Mode
