Stopping a constant variable cell from being copied.

  • Thread starter Thread starter Link
  • Start date Start date
L

Link

Let's say I have a constant variable in cell A1

Then let's say that C1 = B1+A1, and C2 = B2+A1, and C3=B3+A1.

Well if I want to copy C3 and paste it into C4 to C50, Excel will add to the
A1 cell (eg. C4=B4+A2, etc), but I want that to be a constant variable (like
an interest rate).

How can I 'lock it in' so that when a reference of it is copied, the
reference remains the same?

Any advice gratefully received.

Cheers,
Link.
 
Put instead in C1: =B1+$A$1
Copy down. The dollar signs in $A$1 will fix it to A1 as required.
 
Perfect! And so easy! Thanks very much Max, I wish I had asked this months
ago!;-)

Cheers,
Link.
 
Back
Top