Microsoft Office Tutorials and References

In Depth Information

**Copying Formulas: More Than Just Duplication**

Introducing an Absolute Cell Address

What we do is edit the original source formula in cell L8—the cell containing John’s

bonus—to read

=K8+N
$
7

Note the obvious change: the addition of a dollar sign to the left of the 7, which identifies

the row in the cell reference of N7. The dollar sign doesn’t represent a currency format;

rather, it freezes the 6 so that when you copy this formula down the L column, the cell

reference N7 won’t change.

To see what that means, delete the bonus data in the L column and enter

=K8+N$7

in John’s bonus score cell of L8. Copy that formula down the column again. You should

see the data shown in Figure 4–26.

Figure 4–26.
That’s more like it!

Save the workbook. At last, the bonus has been applied to all the students, because
all

the bonus cell formulas now reveal the

reference, which won’t change, even if you

were to copy it down 1,000 rows. Check any bonus cell out to see what I mean.

N$7

And by the same token, if the test scores had been entered this way—that is, horizontally

(with the data beginning in cell J9), you’d see the results shown in Figure 4–27.