Let's say that I have a value in cell A5 that is being used to calculate a value in A3.
A3 = (A1 + A2) * A5
When I copy paste cells A1:A3 and paste onto B1:B3, I'd like the resulting formula to be this:
B3 = (B1 + B2) * A5
Notice that A5 is still there.
It is the default behavior of Excel to cause this to be B5 instead of A5.
Is there a way to force a reference a single cell, such as A5, to be maintained while copy pasting rows?