Printing 1st 2 rows of spreadsheeet on each page

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

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

"Jools" wrote:

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

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" wrote in message
...
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
--
Jools

"Jools" wrote in message
...
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 !)

Page Setup/ Sheet/ Rows to repeat at top/ ...
--
David Biddulph

-----Original Message-----
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
--
Jools
.
If I understand your question correctly, go to File, Page
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.