What finally helped me break that cycle was learning to use named ranges in Excel not only as stable anchors but also as ...
Is there a way to hold down shift/ctrl, etc to make a cell reference an absolute reference when entering a formula instead of having to go back and enter $?