How can I print repeating rows on every page when printing?

M

mamallama

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

Loris

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

CLR

The term "A1:J1" is not a formula, it is only a reference to a range of
cells....if for instance you wanted to add the values in all those cells,
you could use the formula =SUM(A1:J1)

To repeat rows at the top of printouts, do File > PageSetup > SheetTab >
click on the arrow by the RowsToRepeatAtTop window, and then select the rows
you want, then > OK

Vaya con Dios,
Chuck, CABGx3
 
Top