Microsoft Office Tutorials and References
In Depth Information
To Create a Percent Series Using the Fill Handle
The next step is to create the percent series in column B using the ﬁ ll handle. These percent ﬁ gures will serve
as the input data for the data table.
1
With cell B10 selected, enter
4.50% as the ﬁ rst number in
the series.
upper-left cell of
one-input data table
should not contain
an input value
Select cell B11 and then enter
4.75% as the second number in
the series.
ﬁ rst two
numbers
of series
Select the range B10:B11.
Drag the ﬁ ll handle through
cell B23 to create the border of
the ﬁ ll area as indicated by the
not release the mouse button.
ﬁ ll handle
dragged
through
cell B23
ScreenTip
indicates last
value in series
Figure 4–22
2
Release the mouse button to
generate the percent series
from 4.50 to 7.75% and display
the Auto Fill Options button.
Click cell C9 to deselect the
range B10:B23 (Figure 4–23).
What is the purpose of the
percent ﬁ gures in column B?
Excel will use the percent
ﬁ gures in column B to calculate
the formulas to be evaluated and
entered at the top of the data
table in row 9. This series begins in
cell B10, not cell B9, because the
cell immediately to the left of the
formulas in a one–input data table
should not include an input value.
cell C9 is
active
Excel extends
percent series
to cell B23
Auto Fill
Options
button
Figure 4–23
Other Ways
1. Right–drag ﬁ ll handle in
direction to ﬁ ll, click Fill