hi
use absolute references
=sum($A$4:$A$8)
the $ signs will force xl to keep the references.
relative references change as you move the formula around the sheet, keeping
it's references relative to it's new positions.
read up on absolute references vs. relative references in help.

regards
FSt1

"fruitchunk" wrote:

I would like to know how to stop excel from adjusting references
automatically when inserting a new row.

Example:
A1=SUM(A4:A8)

If I insert a new row on A4 the formula on A1 will now be =SUM(A5:A9)
How can I stop it from adjusting automatically,
I want A1 should always be =SUM(A4:A8) no matter if I insert a new row.

Please help, Thanks.