Page layout - Printing Titles

[Dag]

I have Worksheet as following:

Large text is to be here as the main heading (but not header)
1. A data B data C data D data E data F data
* * *
And large comment is to be here which is large and large and large.

When I make "Repeat columns A:A and B:B, first page print is OK but the second page looks like:

Large text is to be here as th
1. A data G data H data I data J data K data
* * *
And large comment is to be h

Is there any trick to solve this problem? Or to avoid repeating of heading and comment (or some cells that are in repeated columns)? Or absolutely another solution should be used?

Thanks in advance.

 

[indiantrix]

Rather than repeating columns, try this: Rows to repeat at top.
then if you want the first two rows, put this in that field:
$1:$2
This command will place the first two rows of your sheet at the
top of each printed page.
Hope I understood you correctly.
Larry.

 

[Dag]

Thank you Larry.

But it is not the case. Repeat rows when you have many pages (ec. portrait print - top to bottom). I have landscape with a lot of data so I need to repeat columns, not rows (left to right).

For example:

                    jan  feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec
Some calc 1
Some calc 2
Some calc 3
Some result:
* * *

Print:

Page first:
                    jan  feb  mar  apr  may  jun
Some calc 1
Some calc 2
Some calc 3
Some result:
* * *
Page second:
                    jul  aug  sep  oct nov  dec
Some calc 1
Some calc 2
Some calc 3
Some result:
* * *

Perhaps there are no any solution in Excel... maybe to play with Page second in PDF...

 

[DCIII]

I have an issue where I am unable to get my custom header to appear correctly on the spreadsheet. Each time I create one, Excel adds in a piece I didn't intend. Please help!

Thanks.