Microsoft Office Tutorials and References
In Depth Information
To Enter Dummy Data in the Template Using the Fill Handle
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
Figure 6–7
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
fi 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 fi 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 fi rst cell, selecting the range to fi 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
defi ne start value and
increment value
series 2 through 14
created in range C5:
C11 using fi ll handle
Figure 6–8
Other Ways
1. Enter fi 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
Search JabSto ::

Custom Search