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?

What did you hope would happen with your formula?

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

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?

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


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