cell reference problem - help!!!!

[dz]

I have a formula similar to the following:

=(E2+F1)

When I copy the row and paste it below the previous entry,
the reference correctly changes to: =(E3+F2). No matter
how many rows I copy/add under the previous entry, it
always correctly recalcs the references.

However, if I paste the row between two entries, it does
the following:

Row 2 = =(E2+F1)
Row 3 = =(E3+F1) - it should be (E3+F2)
Row 4 = =(E4+F3)

I also tried using the R1C1 reference style under tools,
options, general, but it still incorrectly "fills" row 3.

Does anyone have any ideas? I'm desperate. Thanks.

 

[Katherine Coombs]

Hi DZ,

Instead of copying and pasting the formula, drag it down. For example, in
cell D2 you type in =E2+F1 and then press Enter. Click back into cell D2
and at the bottom right hand corner you'll see that there is a little black
cross. Hover your mouse over it and it will turn into a + Click and drag
that formula down and it will automatically adjust so that D3 contains the
formula =E3+F2.

HTH,
Katherine

 

[Gord Dibben]

DZ

This problem will arise if you Cut and Paste. If you Copy and Paste you
should not see the duplication.

Gord Dibben XL2002

 

[dz]

Thank you both for your response. However, the row is
programmically copied to the current location (although
the problem occurs whether or not the macro is used).

So, I cannot do the "hover" thing, and it IS copied, not
cut.

Any other suggestions? Thanks.