To repeat rows on each printed page go to the FILE menu and select Page
Setup. Go to the Sheet tab and click inside the box labeled "Rows to Repeat
at the Top" then click on the row header(s) inside your worksheet of the rows
you want to repeat.

"A1:J1" is not a formula but a range. You need an = sign and an operator or
function.

"mamallama" wrote:

Hello, I have used the formula that looks like this, "A1:J1" and it has
worked before, but now it isn't! I may have been using a different version of
Excel (at work). I have the Office XP product here, and I'm stumped.

Also, if I want to repeat two rows at the top of every page, how would I do
that?