Repeat formula with inserted row


F

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!
 
Ad

Advertisements

S

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.
 
F

Fred

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

Advertisements

A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top