I need to paste an area of formulas. One formula needs to use $ ($B$4), when I paste it, it refers back to $B$4 when I want it to stay within the area of formulas, $B$65. Can I set the area of formulas to stay within itself when pasted?
Not sure I understood the question, perhaps we speak about absolute and relative references. Try to use $B4 instead of $B$4.