Absolute reference

Excel glossary definition

A cell reference locked with $ signs so it doesn't change when copied.

Definition

A reference such as $A$1 that stays fixed when a formula is copied to other cells. Use it when a formula must always point at the same cell (for example, a tax rate or a lookup table).

Back to Excel glossary