Printing 1st 2 rows of spreadsheeet on each page

[Guest]

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

 

[Guest]

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

 

[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.

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 !)

 

[David Biddulph]

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/ ...

 

[Guest]

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

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.