i think what the original poster is looking for is that the formula
will automatically populate the newly-inserted line, in the same
column as the previous row (& the row after)............. if i
understand him/her properly.
the only way i can see to do it is to insert the new line, go to the
first cell above that contains the formula, and pull it down
throughout the rest of the list, thereby inserting the formula in the
blank cell & also correcting the rest of the list.
:)
susan



On May 19, 10:26*am, Teethless mama
wrote:
=INDIRECT("B"&ROW()-1)+INDIRECT("A"&ROW())



"HPH" wrote:
How do I insert a new line in a excel spreadsheet without destroying the
consistency of the formulas?

Cut down to a minimum, the following is what I want.

Starting point:
*B2=B1+A2
*B3=B2+A3

Desired result after inserting a new line BETWEEN line 2 and line 3:
*B2=B1+A2
*B3=B2+A3
*B4=B3+A4

I have been using SuperCalc for many years now, where this is a very simple
command. But I have newer been able to make the shift to excel. Just because
I could not figure out how to make this simple insert.
I have been trying at least four different types of relative referencing,
but they are all producing the wrong result:
*B2=B1+A2
*B3=<empty
*B4=B2+A4- Hide quoted text -

- Show quoted text -