Inserting rows that will have all characteristics of previous row

[Kevin Blackerby]

I am working on an excel spreadsheet that has columns and rows that are summed.
Frequently, I have to insert a new row or column. The formatting of the
preceeding cell will carry over to the new cell. However, the summation formula
will not. I know that I can copy the preceeding format cell (with the summation
formula) to the new cell manually. I would really like to know if this can be
done automatically when the new insert is made.

[Dave Peterson]

There are at least two answers:

In xl2k, there's an option under Tools|options (not sure where, don't have it
yet) that tells excel to extend the range when you do this kind of stuff.

In all versions, you could rewrite your formula:

If the cells to total are a1:a5, then put this in a6:

=SUM(A1:OFFSET(A6,-1,0))

the offset says look at 1 row up from A6.

--

Dave Peterson
ec3...@msn.com

[Gord Dibben]

And a third

=SUM(A1:INDEX(A:A,ROW()-1))

Where A1 is the first cell in the sum range.

HTH Gord (XL97 SR-2B)

[David/Adrian]

If you insert the row or column at least one cell away from the 'sum
formula' cell, then the new row or column will be included in the formula
automatically.
It's only when you insert right next to the 'sum formula' cell that it
doesn't include it.
Regards
David (South Wales,UK)

Dave Peterson <ec3...@msn.com> wrote in message
news:3AD38240...@msn.com...