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

þ
0

(CTRL

þ

accent mark) or CTRL

þ
B

(tilde). Notice that the formula reads

¼

C3*D3 in row 3,

¼

C4*D4 in row 4,

¼

C5*D5

in row 5, and so on for all the other rows. This is called

“

Relative Addressing
.

”

The

address is relative to the position of the row and the column.

You may now choose again CTRL

þ
0
or CTRL

þ
B

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

þ
B

view, showing the values, not the formulas. CTRL

acts as a toggle

FIGURE 3.3
Relative Addressing