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

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

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

could you clarify.

Rohin
919884904450

"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

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

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