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
2 Click and drag the cell’s fill handle
across or down the number of
cells that you want to fill.
changes to
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.
Search JabSto ::

Custom Search