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.
• With cell B10 selected, enter
4.50% as the ﬁ rst number in
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
ﬁ rst two
• Select the range B10:B11.
• Drag the ﬁ ll handle through
cell B23 to create the border of
the ﬁ ll area as indicated by the
shaded border (Figure 4–22). Do
not release the mouse button.
ﬁ ll handle
value in series
• 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
to cell B23
1. Right–drag ﬁ ll handle in
direction to ﬁ ll, click Fill
Series on shortcut menu
2. Select range, click Fill
button on Home tab on
Ribbon, click Down