Locking rows for printing

  • Thread starter Thread starter =?iso-8859-1?Q?Mika_Wil=E9n?=
  • Start date Start date
?

=?iso-8859-1?Q?Mika_Wil=E9n?=

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
 
-----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
 
Mika

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

Andy.
 
Back
Top