Microsoft Office Tutorials and References
In Depth Information
Extend a series with
AutoFill gives you a way to ensure accurate data
entry when a particular data series has an intrinsic
order: days of the week, months of the year, numeric
increments of two, and so on.
To use AutoFill, start by typing one or more values
from which you will generate other values. Select the
cell or cells you want to extend. Selecting two or
more cells determines the step size, or increment, by
which you want to jump in each cell. With the cells
selected, click the Fill handle in the lower-right corner
and drag. When you release the mouse button, Excel
fills the cells with values.
After filling the cells, Excel provides a menu button.
Click the button to open a menu that enables you to
change the fill. You can copy the initial value; fill the
series one day at a time; or extend it by weekdays,
months, or years, depending on the type of fill you
Type the initial value for the
series you want to create.
Select the cell or cells.
Click the Fill handle.
4 Drag the desired number of cells
and release the mouse.
l Excel fills the cells with a series.
l The AutoFill Options button
Click the button.
A menu appears.
Click Copy Cells (