Calculation

Excel formula

Absolute Reference | # gomaths.net/4241     

An absolute reference in a formula does not change when the formula is copied or filled.

An absolute reference uses $ signs,

=$B$1 the column and row do not change.
=$B1 the column does not change
=B$1 the row does not change