Repeat formula with inserted row
 

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!

Repeat formula with inserted row
 

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.

--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast


"Fred" wrote:

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!

Repeat formula with inserted row
 

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



"Satti Charvak" wrote:

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.

--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast


"Fred" wrote:

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!

Repeat formula with inserted row
 

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

"Fred" wrote in message
...
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!