Absolute & Relative Referencing

Absolute & Relative Referencing

There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant, no matter where they are copied.

Relative Reference

C1 = A1 + B1

Absolute Reference

C1 = $A$1 + $B$1

11KB

Absolute_Relative_Reference.xlsx

Example of Absolute & Relative Reference