View original (French)

Copying and pasting a column while keeping the same formula references.

Bakus -  
Raymond PENTIER Posted messages 58207 Registration date   Status Contributor Last intervention   -
Hello,

I would like to know how to copy and paste a column containing a formula into another column while keeping the same formula references. That is, if I have in column B a formula that is =E1+E2 and I copy this column to C, instead of having =F1+F2, I want to keep =E1+E2.

Thank you in advance

Configuration: Windows / Internet Explorer 11.0

4 answers

Answer 1 / 4
Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 783
 
Hello,

In 4 steps:
1. Copy / Paste below in the same columns
2. Cut / Paste in the same rows below the destination
3. Copy / Paste to the destination (in the same columns)
4. Clear the source from step 3

Best regards
Patrice
4