Printing 1st 2 rows of spreadsheeet on each page

J

Jools

Really simple question, haven't been at this for to long, and all I want to do is have my column headings show on each page when I print. (not the labels - I know how to do that one !)

Thanks
 
V

Vaughan

Not too taxing this one:

Select File, Page setup and go to the Sheet tab. Just type "1:2" or whatever (without the quotes) in the "Rows to repeat at top" box
 
A

Andy B

Hi

From File / Page Setup go to the Sheet tab and select the area in the 'Rows
to repeat at top' box. You can either select the box and then 'rubber-band'
them on the sheet, or just type in the references ($1:$2)

--
Andy.


Jools said:
Really simple question, haven't been at this for to long, and all I want
Click to expand...
to do is have my column headings show on each page when I print. (not the
labels - I know how to do that one !)
 
D

David Biddulph

Jools said:
Really simple question, haven't been at this for to long, and all I want
Click to expand...
to do is have my column headings show on each page when I print. (not the
labels - I know how to do that one !)

Page Setup/ Sheet/ Rows to repeat at top/ ...
 
G

Guest

-----Original Message-----
Really simple question, haven't been at this for to long,
Click to expand...
and all I want to do is have my column headings show on
each page when I print. (not the labels - I know how to
do that one !)
Thanks
Click to expand...
Setup, Sheet and there is a box for Rows to Repeat at
top. You can type in the rows or highlight which rows you
wish to repeat.
 
Top