Section 8 - Absolute Addressing
Absolute addresses do not change during copying. Absolute
addresses are specified by preceding the row and column
address of the cell reference with a $. For example, $A$1
is an absolute address.
After highlighting a cell reference, you can use the F4
key as a shortcut on a PC to toggle the state of a cell
reference through Relative, Absolute, and Mixed.
|
Type of Addressing
|
Example
|
|
Relative
|
B1
|
|
Absolute
|
$B$1
|
|
Mixed
|
$B1 or B$1
|
|