References In Excel
RELATIVE & ABSOLUTE ADDRESSING
There are different sorts of cell references. These are:
A relative reference will change column and row numbers as it is copied to other
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
$A4 or A$4
File Size: 377.5kb