Print Titles - Columns to Repeat at Left

G

Guest

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
 
P

Pete_UK

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
 

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

Similar Threads

Print Titles: Repeating both left column and top rows 2
Repeat Rows at Top - Except Final Page 2
Change print titles (rows to repeat at top) on subsequent pages 2
Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec 2
How to set up Excel to print wrapped columns on a page. 1
Printing very large spreadsheet 1
Print titles must be contiguous and complete rows or columns 18
Columns to Repeat at Left are Truncating 1

Top