| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| Sum only adding rows on page instead of entire spreadsheet - help | 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
