Repeat formula with inserted row

[Fred]

Hi, really need some help with the new Excel.

In row 7 I have it setup that K7=(H7-E7) and so row 8 is K8=(H8-E8).
Trouble I am having is that when I "insert" row 9 the formula does not repeat
and I have to type K9=(H9-E9). What or how do I have to set it up so that
any time I "insert" a row that it understands it needs to repeat the formula
from the row above it?

Thanks!

 

[Satti Charvak]

Just select the complete row, above which you want to insert a row, then
click copy and then insert the copied row above it. The new row would be like
the one copied and the formulas will also be copied and updated to new values.

 

[Fred]

Thank you! That way of doing it makes it very simple and easy! No idea why
I did not think of that. Thanks!

 

[Ashish Mathur]

Hi,

Assume your range is as stated below. You can try the following:

1 Select the entire range of cells (Range A1:C5);
2. Go to Data > list > Create List (in Excel 2003). Insert > Table (in
Excel 2007)

Number 1 Number 2 Total
1 2 3
23 45 68
34 89 123
78 90 168

Now when you insert data in A6 and B6, the formula in C6 would appear
automatically

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com