A cell reference that remains fixed when a formula is copied. It's marked by $ signs (for example, $A$1) to lock both column and row.
In the formula =A1*$B$2, the reference to B2 is absolute, so copying the formula to other cells always multiplies by the value in B2.
