Microsoft Office Tutorials and References
In Depth Information
Faster Data Entry with AutoFill
AutoFill a Number Series
1 Type the first entry in the number
2 In an adjacent cell, type the next
entry in the number series.
3 Select both cells.
Note: See the previous section, “Select
Cells,” to learn more.
4 Click and drag the fill handle across or
down the number of cells that you
want to fill.
changes to .
5 Release the mouse button.
AutoFill fills in the number series and
selects the series.
D The AutoFill Options button ( ) may
appear, offering additional options
that you can assign to the data.
How do I create a custom list?
To add your own custom list to AutoFill’s list library, first
create the custom list in your worksheet cells. Then select
the cells containing the list that you want to save. Click
the File tab and then click Options . In the Options dialog
box, click the Advanced tab. In the General section, click
the Edit Custom Lists button. In the Custom Lists dialog
box, click Import . Excel adds your list to the series of
custom lists ( A ). The entries in the list appear here ( B ).
Click OK to close the Custom Lists dialog box. Click OK
again to close the Options dialog box