Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have sent up a 6 pages spreadsheet that has repeating columns (campus code
and campus name) at the left of each pages, using Print Titles - Columns to Repeat at Left. The problem is that my report title (which is part of the "rows to repeat at the top" of each page) is printing correctly on the first page, but then is being cut off on pages 2-6. Any ideas how to fix this? Thanks, Rebecca |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If yours is a very wide sheet, then the columns to print on the left
will appear on each page as it is meant to read left-to-right. However, the rows at the top will only print on pages meant to be below the first page, i.e. for long sheets. Maybe you need to think about setting up a header, as this will appear on each page, or copy your initial cells across to where your other (printed) pages occur. Hope this helps. Pete On Oct 29, 6:34 pm, Rebecca_SUNY wrote: I have sent up a 6 pages spreadsheet that has repeating columns (campus code and campus name) at the left of each pages, using Print Titles - Columns to Repeat at Left. The problem is that my report title (which is part of the "rows to repeat at the top" of each page) is printing correctly on the first page, but then is being cut off on pages 2-6. Any ideas how to fix this? Thanks, Rebecca |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change print titles (rows to repeat at top) on subsequent pages | Excel Discussion (Misc queries) | |||
merged cells don't center over columns to repeat at left | Excel Discussion (Misc queries) | |||
Columns to Repeat at Left are Truncating | Excel Discussion (Misc queries) | |||
Print titles: can noncontiguous columns at left be printed & how? | Excel Worksheet Functions | |||
Cell Borders and "Columns to Repeat at Left" | Excel Discussion (Misc queries) |