See if this helps (XL2007):
Office buttonExcel OptionsAdvancedExtend data range formats and formulas

Regards,
Fred

"DF" wrote in message
...
I was wondering if there was an automatic way of copying it. I am not
going
to be the only user, and I really need to reduce the chance of errors
creeping in, which will ultimately skew all the data on a linked
worksheet.
I don't understand macros at all...

"Rohinikumar" wrote:

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