Locking rows for printing

M

Mika Wilén

I'd like to know how to lock the 1st row on the 1st page
of a worksheet so that it is also printed on each of the
following pages.

Grateful for any hints.

Mika
 
E

Eddie

-----Original Message-----
I'd like to know how to lock the 1st row on the 1st page
of a worksheet so that it is also printed on each of the
following pages.

Grateful for any hints.

Mika
Click to expand...

Mika - go into Page Set up - sheet - rows to repeat at top
and type in $1:$1, where the 1 would represent the rows
you want to repeat. Should you wish to repeat further
rows, then change the second "$" to 2,3,4 etc.

Regards

Eddie
 
A

Andy B

Mika

Go to File/Page Setup/Sheet/Rows to repeat at top and input or select what
you require.

Andy.
 
Top