Microsoft Office Tutorials and References
In Depth Information
Relative and Absolute Addressing
information. The cells G2, G3, and the following cells are empty. See the results and
the problem in Figures 3.4 and 3.5.
Other than the correct result in cell F3, all the others result in a zero (0).
Revealing the formulas in Figure 3.5 shows that using G1 in the formula with relative
addressing causes the rest of the cells in column F to use G2, G3, G4, and so on in the
formulas. The other cells are all empty and they cause the problem encountered in
To overcome this relative addressing problem, we have to be able to refer to cell G1
in all the formulas in the cells in column F. This concept, using a specific cell and not a
range, is called Absolute Addressing ; we want all formulas in the series to refer to one
specific cell only. To do so, we have to change G1 in these cells
formulas to read $G$1.
When you see the $ signs in G1, it means that G1
s status in the following formulas in
the column has been changed from Relative Addressing to Absolute Addressing .
As shown in Figures 3.5 and 3.6, you want to use absolute addressing for G1 in
cell F3. Select cell F3, type
, click on E3 and type *, and click on G1. Before doing
anything else, press the F4 key on the keyboard. The F4 key changes G1 to read
$G$1. [For the Mac use
T.] This is referred to as Absolute Addressing . When you
use Enter (or as explained before, click the green check sign
to the left of
FIGURE 3.6 Use Absolute Addressing for Cell G1