hi just click on which cell have already formula and click CTRL +C and CTRL
+V on which cell you want formula


"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