Creating an Absolute Reference in a Formula

[ LiB ]

Occasionally when you copy a formula, you do not want one of the cell references to change. That's when you need to create an absolute reference . To indicate an absolute reference, use the dollar sign ($).

It's called an absolute reference because when you copy it, it absolutely and positively stays that cell reference and never changes. An example of a formula with an absolute reference might be =B22*$B$24. The reference to cell B24 will not change when copied .

NOTE

Compound formulas can also have absolute references.

[ LiB ]