auto formula when insert new row

Q

Quan Nguyen

I have a simple sheet:
A | B | C
1: 5 | 4 | =A1+B1
2: 5 | 4 | =A2+B2
3: 5 | 4 | =A3+B3


when i insert a row before line no 2.
A | B | C
1: 5 | 4 | =A1+B1
2:
3: 5 | 4 | =A3+B3
4: 5 | 4 | =A4+B4

i want C2 have formula: =A2+B2 automatically. but i can't.
please tell me how to make it?
 
K

KC Rippstein hotmail com>

If you have Excel 2003, highlight all your data and go to Data | List |
Create List. Excel 2003's built-in List feature carries the formulas and
formatting automatically to new data.
When you need to insert (using your example), you don't actually click the
"2"...instead, you position your cursor on the right edge of the 2 and then
right click from there. The List menu options appear, and one is to
Insert>Row.
Earlier versions of Excel do not have this feature, though.
-KC
 
D

Dave Peterson

You may want to try
Tools|Options|Extend data range formats and formulas

But that has never worked the way I expected (for me). I turn that setting
off. I don't understand the rules that it uses. I always copy and paste.

If you want a macro that may do what you want, visit David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Top