Hi

If you are using XL2003
Place cursor in your dataDataListCreatecheck my List has headers

If you are using XL2007
Place cursor in your dataInsert tabTablecheck my table has headers

Now, if you want to insert a row, right click where you wish to
InsertInsert Row
The new row will have your formulae automatically created.
Similarly, if you add new rows to the end of the List / Table

--
Regards
Roger Govier

DF wrote:
I am not very technical when it comes to excel, and am creating a sheet. I
have various information in each column, and in two of them I have formula
eg - (on row 1)
A1, B1 has personal info .
C1, D1 have formula inserted, which work

I have copied the formula/ data down to say Row 18.

when I insert a new row inbetween rows 1 & 18 the formula is not copied
down/ up
eg - (on row 2)
A2, B2 I want to remain blank, so I can input the data
C2, D2 I want the formula automatically copied.

How do I do this? Please help, and please try and keep it simple I'm not
very computer literate! thanks in advance