in the box you need to enter $1:$2. The easy way to do this is to click in
the row to repeat box and use the mouse and clicl on the rows you want to
repeat.
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"kdhelm" wrote:

Thank you Andrea, what does it mean when it says I do not have a valid
reference. I want to print row 1 and row 2 what do I enter in the box and
how should it read?
Thanks

"Andrea" wrote:

if you mean how to repeat rows and columns each page:
go to page setup, sheet Tab and than you can input wich row to repeat on top
and wich column to repeat at left
Andrea

"kdhelm" wrote:

How do you set computer to print "freeze panes" on succeeding pages in excell?