I have a formula in a cell (marked with a circle) that has a range.
I move V6082 to the right - it is now in the range of the formula and result is updated.
Now, when I move V6082 back to the original position the range of the formula changes (red rectangle).
How do I prevent this from happening? I need the range to stay in place, not going with the cell when I move it. I need to move cells with mouse/drag because it is sensitive data and Ctrl-x/Ctrl-v is not an option. Also, dollar signs don't work in this regard.
Thanks.
I move V6082 to the right - it is now in the range of the formula and result is updated.
Now, when I move V6082 back to the original position the range of the formula changes (red rectangle).
How do I prevent this from happening? I need the range to stay in place, not going with the cell when I move it. I need to move cells with mouse/drag because it is sensitive data and Ctrl-x/Ctrl-v is not an option. Also, dollar signs don't work in this regard.
Thanks.
Last edited: