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
=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
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.
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.