Formulas

L

Leo

How can a freez a portion of my formula so that it keeps
a specific referenced cell when I'm copying in a column.
Expmp. (c1 + C2) I want the reference to c1 to stay c1
and the c2 to change to c3.. c4.. c5.. when copying down
a column.
 
J

JulieD

Hi Leo

click in the formula on the C1 and press the F4 key it will change to $C$1
(you could type the $ if you really want) - this "freezes" (makes the
reference absolute rather than relative) both the column and row reference
(other options are $C1 (column stays absolute - row is relative) or
C$1(column is relative - row is absolute)

Regards
JulieD
 
Top