Microsoft Office Tutorials and References
In Depth Information
MAX and MIN—Recording Highs and Lows
=D6+7
We see, then, that the 7 won’t change—only the original D5 will.
And when you need to copy a formula containing cell references down a column or across a row,
there’s a most expeditious way to do so, by finding a novel use for a tool we already know —the fill
handle. To illustrate:
Let’s take a few steps back in the design of our grading sheet, and for the sake of clarity, we’ll scrub
away all the fancy formatting, too. We’ve written Alice’s AVERAGE formula, and now want to copy it
down the column, as in Figure 3–23:
Figure 3–23. Alice’s average will serve as the formula to be copied
If I station my mouse over the fill handle in cell I10—Alice’s test average—and then click the handle,
don’t release the mouse, and drag down the column through Ringo’s cell in cell I19 and then release the
mouse, I will have copied all the student AVERAGE formulas, as in Figure 3–24:
 
Search JabSto ::




Custom Search