Forum Discussion

JJVega's avatar
JJVega
Copper Contributor
Sep 26, 2023

Copying without refreshing references

Hello,    I'd like to copy a formula in a cell to another cell without refreshing references, I mean, exactly the same formula en other location. I know that i can move the formula with "CtrlX" but...
excel
SanthoshKunder's avatar
SanthoshKunder
Iron Contributor
Sep 26, 2023

JJVega - If you don't want to change the reference to absolute then this should help.

 

Let's say you have this formula in cell B1 = SUM(A1:A5). We first need to replace = with #. We can use CTRL+H to do this. Now formula is gone in cell B1 and only the text #SUM(A1:A5) is left. 

 

Copy the text #SUM(A1:A5) , paste it in the cell you want and do the reverse replace( # to=)

 

Hope this helps!

 

  • JJVega's avatar
    JJVega
    Copper Contributor
    Sep 26, 2023

    SanthoshKunder,

     

    That is a good idea (#/=) when a massive copy is needed.

     

    Thanks!

     

     

     

     

Resources