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
InsertRow.
Earlier versions of Excel do not have this feature, though.
-KC
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Quan Nguyen" wrote:

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?