Forum Discussion
Solved
In Excel cut and paste may change the cell range set in a formula
I have an Excel sheet where I defined a sum of four cells with SUM($A$2:$D$2): A B C D SUM 1 2 3 4 10 The issue I noticed is that if user selects cell A2 and then cut...
After some more thinking I found a workaround: in the cell range I added a hidden cell before and after the range of cells where users enter values:
That way, it someone cuts any of the visible cells and pastes it inside the range, the SUM formula won't change as the first and last cells in the range are not affected by the cut&paste.
That's by design!
Don't cut and paste but copy and paste and then empty the cell copied from. Thus copy A2, paste in B3 (for example), select A2, press the delete button on your keyboard.