Microsoft Office Tutorials and References
In Depth Information
To Copy Formulas Using the Fill Handle
The four formulas for Apple Computers in cells F4, H4, I4, and J4 now are complete. You could enter the
same four formulas one at a time for the eight remaining stocks. A much easier method of entering the formulas,
however, is to select the formulas in row 4 and then use the ﬁ ll handle to copy them through row 12. Recall from
Chapter 1 that the ﬁ ll handle is a small rectangle in the lower-right corner of the active cell or active range. The
following steps copy the formulas using the ﬁ ll handle.
• Select cell F4 and then point to
the ﬁ ll handle.
• Drag the ﬁ ll handle down through
cell F12 and continue to hold the
mouse button to select the
destination range (Figure 2–11).
source area is cell F4
of ﬁ ll handle
ﬁ ll handle dragged
through cell F12
• Release the mouse button to copy
the formula in cell F4 to the cells
in the range F5:F12.
• Select the range H4:J4 and
then point to the ﬁ ll handle
initial costs of
range H4:J4 selected
as source area
Auto Fill Options
after copying cell F4
to range F5:F12