Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Print Titles - Columns to Repeat at Left

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default Print Titles - Columns to Repeat at Left

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change print titles (rows to repeat at top) on subsequent pages Eric Excel Discussion (Misc queries) 3 April 4th 23 10:12 AM
merged cells don't center over columns to repeat at left trimatrixlabs Excel Discussion (Misc queries) 0 September 25th 06 04:39 PM
Columns to Repeat at Left are Truncating Bluesky Excel Discussion (Misc queries) 1 April 26th 06 09:29 AM
Print titles: can noncontiguous columns at left be printed & how? HatMar Excel Worksheet Functions 2 November 21st 05 09:47 PM
Cell Borders and "Columns to Repeat at Left" DeLeo Excel Discussion (Misc queries) 0 July 28th 05 03:41 PM


All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"