You want to use
in row 6 =OFFSET(A5,-1,0) instead of =A5
see http://www.mvps.org/dmcritchie/excel/offset.htm
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"MJS" wrote in message ...
I'm not sure I'm posting this in the right place but here goes.

I'm using Excel 2007. Excel is "supposed" to default to copying formulas
into inserted rows by default (assuming previous rows have the same formula).
I've also ensured the option to Extend data range formats and formulas is
checked in [Windows Symbol]-Excel Options-Advanced.

My formulas are not being copied to the inserted row and one formula in the
row below where a relative reference to the row above is not adjusted
correctly (i.e. a simple "=A5" for row 6 on insert remains "=A5" rather than
adjusting to "=A6").

So two different problems but both occurring when I try to insert a row.

Any idea why this isn't working properly?

MJS