software

Hello, I have used the formula that looks like this, quot;A1:J1quot; 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?

quot;mamallamaquot; wrote:

gt; Hello, I have used the formula that looks like this, quot;A1:J1quot; and it has
gt; worked before, but now it isn't! I may have been using a different version of
gt; Excel (at work). I have the Office XP product here, and I'm stumped.
gt;
gt; Also, if I want to repeat two rows at the top of every page, how would I do
gt; 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 quot;Rows to Repeat
at the Topquot; then click on the row header(s) inside your worksheet of the rows
you want to repeat.

quot;A1:J1quot; is not a formula but a range. You need an = sign and an operator or
function.

quot;mamallamaquot; wrote:

gt; Hello, I have used the formula that looks like this, quot;A1:J1quot; and it has
gt; worked before, but now it isn't! I may have been using a different version of
gt; Excel (at work). I have the Office XP product here, and I'm stumped.
gt;
gt; Also, if I want to repeat two rows at the top of every page, how would I do
gt; that?

The term quot;A1:J1quot; 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 gt; PageSetup gt; SheetTab gt;
click on the arrow by the RowsToRepeatAtTop window, and then select the rows
you want, then gt; OK

Vaya con Dios,
Chuck, CABGx3quot;mamallamaquot; gt; wrote in message
...
gt; Hello, I have used the formula that looks like this, quot;A1:J1quot; and it has
gt; worked before, but now it isn't! I may have been using a different version
of
gt; Excel (at work). I have the Office XP product here, and I'm stumped.
gt;
gt; Also, if I want to repeat two rows at the top of every page, how would I
do
gt; that?