You were using Excel 2003. What version are you using now? If it's Excel
2007, it works the same as Excel 2003 in regards to addresses.

Tyro

"Larry" wrote in message
...
This was never a problem in Excel 2003. I am trying to copy and paste a
row
in new rows I have inserted. I have tried relative references, but then
the
formula in the cell I copied remain the same. The self help section for
this
says that if a formula is copied and pasted the relationship will not
change,
but it does.
Here is my formula: =SUM((B138-B137)/G138)
I used this to automatically figure my gas mileage and ran out of rows, so
I
need to insert rows with the same formulas across the row. When I copy the
row, the formula changes to this for the copied cell
=SUM((B138-B136)/G138).
None of this ever happened with Excel 2003. I could create new rows, copy
and
paste the formulas and the reference would remain the same.

"Gord Dibben" wrote:

$A$1

See help for more on relative and absolute references.


Gord Dibben MS Excel MVP


\On Thu, 5 Jul 2007 11:00:02 -0700, Susan

wrote:

If you are referencing a cell in a formula and you want it to remain the
same
when you copy and paste the formula into another cell, how do you enter
it?

Susan