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