Inserting a cell without altering forumlaes

[mercury981]

Hey,

I need help with a very simple problem. I need to insert a row every week on my spreadsheet at work into row 2. I have formulae =average(a2:a6) elsewhere on the sheet, but after an insert it changes to (a3:a7) is there anyway I can lock the formulae to remain selected on cells a2:a6 after a row insert?

Thanks

[Teethless mama]

Hey,

I need help with a very simple problem. I need to insert a row every week on my spreadsheet at work into row 2. I have formulae =average(a2:a6) elsewhere on the sheet, but after an insert it changes to (a3:a7) is there anyway I can lock the formulae to remain selected on cells a2:a6 after a row insert?

Thanks

=AVERAGE(INDIRECT("A2:A6"))

[chris1975]

average($a$2:$a$6)