References In Excel

RELATIVE & ABSOLUTE ADDRESSING

There are different sorts of cell references. These are:

•             Relative
•             Absolute
•             Mixed

A relative reference will change column and row numbers as it is copied to other
cells

An absolute reference is one that does not change

A mixed reference is one that is half relative and half absolute.

An absolute address is defined with the use of the “$” symbol. This can be typed in
at the time of creating the formula, or by editing the cell afterwards.

Examples of relative and absolute
addressing:

Relative
A4
A4:B5
Absolute
$A$4
$A$4:$B$5
Mixed
$A4 or A$4
$A4:B$5