When I add a row to excel how can I stop formulae changing

[Dave L]

I've done this before, but can't remember how.
I want to add a row at the top of a sheet, but without formulae with a range
eg =sum(a1:a5) changing to =sum(a2:a6).
$ isn't the answer

[vezerid]

=SUM(INDIRECT("A1:A5"))

HTH
Kostis Vezerides

[Dave L]

"vezerid" wrote:

> =SUM(INDIRECT("A1:A5"))
>
> HTH
> Kostis Vezerides
>
Thanks for that.
How about if I after inserting a row A1:A5 changes to A1:A6

TIA
Dave