Microsoft Office Tutorials and References
In Depth Information
Faster Data Entry with AutoFill
Faster Data Entry
with AutoFill
You can use Excel’s AutoFill feature to add duplicate
entries or a data series to your worksheet. In addition
to creating your own custom data lists, you can use
Excel’s built-in lists of common entries such as days
of the week, months, and number series. When you
click a cell, a small fill handle appears in the lower
right corner of the selector; you use this to create an
AutoFill series.
Faster Data Entry with AutoFill
AutoFill a Text Series
1 Type the first entry in the text
series.
2 Click and drag the cell’s fill handle
across or down the number of
cells that you want to fill.
1
The
changes to
.
2
You can also use AutoFill to copy
the same text to every cell that
you drag over.
3 Release the mouse button.
AutoFill fills in the text series.
An AutoFill smart tag ( ) may
appear, offering additional options
that you can assign to the data.
146
 
Search JabSto ::




Custom Search