The method of specifying absolute cell addresses follows the convention of
Lotus 1-2-3. Absolute references are preceded by a dollar sign ($). The
dollar sign can precede either the column reference, row reference, or both.
Here are some examples:
- K20
- This references cell K20. Both the column and row references
change when the cell is copied.
- $K$20
- This references cell K20. Both the column reference and row
reference remain fixed when the cell is copied.
- $K20
- This references cell K20. The column reference remains fixed but
the row reference changes when the cell is copied.
- K$20
- This references cell K20. The column reference changes but the
row reference remains fixed when the cell is copied.
These conventions also hold on defined ranges. Range references vary when
formulas containing them are copied. If the range is defined with fixed
variable references, the references do not change.