Hi,

If I have formula like A1=$A$2+$A$3 and then I cut/paste cells A2 and A3 to B2 and B3, then my formula will change to A1=$B$2+$B$3. Can I lock it somehow?
I need it to keep calculating A1=$A$2+$A$3, even dought I have moved A2/A3 to different place.

Many thanks