I have numbers in cells C1, D1, E1, numbers are 1,2,3 respectably. Formula in cell A4 is =sum(C1:E1) and it's returning 6. When I select cells C1 and D1 and cut and paste in cell B1 formula is changing it range to B1:E1. I'm not touching formula it self, just changing cell values. I do not want that, formula should stay the same =sum(C1:E1). I have also tried with absolute references; =sum($C$1:E$1$) but when I cup/past values formula is also changing.
Is there any way to stop this behavior. Moving data between cells should not change reference of formulas in other cells.