Microsoft Office Tutorials and References
In Depth Information
Relative and Absolute Addressing
FIGURE 3.2 Double-Click to Copy Down All the Result
When the operation is completed in cell E2, we are ready to copy/drag down the
formula to the rest of the cells in column E
the last cell that has
data/information in the adjacent column D. We do not copy and paste, and though you
can drag down, it is not the most efficient way. (Imagine if you had 2,000 employees!)
Point to the drag handle, on the lower right corner of the cell, and when the mouse
pointer takes the shape of a crosshair (
all the way to E8
), double-click and the formula will be
transferred/copied to the rest on the cells in column E. Figure 3.2 shows the results.
RELATIVE AND ABSOLUTE ADDRESSING
You will notice that copying or dragging a formula does not copy the values down.
You copied the formula only. Figure 3.3 shows all the formulas on the sheet. To
reveal the formulas on a sheet choose CTRL
accent mark) or CTRL
(tilde). Notice that the formula reads
C3*D3 in row 3,
C4*D4 in row 4,
in row 5, and so on for all the other rows. This is called
Relative Addressing .
address is relative to the position of the row and the column.
You may now choose again CTRL
þ 0 or CTRL
to turn back to the initial
you can go from one view to the other. You can also use the Show Formulas icon
under the Formulas Ribbon:
The next step on the simple payroll spreadsheet is to calculate the tax for all the
rows. We want to multiply the salaries in column E by the Tax Rate in cell G1 as
shown in Figure 3.4.
þ 0 or CTRL
view, showing the values, not the formulas. CTRL
acts as a toggle
FIGURE 3.3 Relative Addressing