Microsoft Office Tutorials and References
In Depth Information
To Enter Dummy Data in the Template Using the Fill Handle
2
Release the mouse button to
create the series 1 through 7
in increments of 1 in the
range B5:B11 (Figure 6–7).
series 1 through 7
created in range
B5:B11
Figure 6–7
3
Select cell C5. Type 2 and then
press the DOWN ARROW key.
Type 4 and then press the
ENTER key.
Select the range C5:C6. Drag the
ﬁ ll handle through cell C11 to
create the series 2 through 14
in increments of 2 in the
range C5:C11 (Figure 6–8).
What other types of series can
I create?
Excel allows you to create many
types of series, including a date
series (Jan, Feb, Mar, etc.), an
auto ﬁ ll series (1, 1, 1, etc.), and
a linear series (1, 2, 3, etc. or 2, 4,
6, etc.), which was created in the
previous steps. A fourth type of
series is a growth series. A growth
series multiplies values by a con-
stant factor. You can create a growth
series by entering an initial value in the ﬁ rst cell, selecting the range to ﬁ ll, clicking the Fill button on the Home tab on
the Ribbon, clicking Series, clicking Growth in the type area, and then entering a constant factor in the Step value box.
values 2 and 4 entered
in cells C5 and C6
deﬁ ne start value and
increment value
series 2 through 14
created in range C5:
C11 using ﬁ ll handle
Figure 6–8
Other Ways
1. Enter ﬁ rst number, while
holding down CTRL key
drag through range
2. Enter start value, select
range, click Fill button on
Home tab, click Series,
enter parameters, click OK
button

Search JabSto ::

Custom Search