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


File Size: 377.5kb
pdf

Now Check This Out

;