Microsoft Office Tutorials and References
In Depth Information
Formatting Numbers, Dates, and Time Values
Creating your own AutoFill list
As you probably know, Excel is capable of
completing lists on its own with the AutoFill feature.
You can enter the days of the week or month
names simply by entering one day or month
and dragging the AutoFill handle to enter the
others. Here’s some good news: The AutoFill
command can also reproduce the names of
your coworkers, the roster of a softball team,
street names, or any other list that you care to
enter quickly and repeatedly in a worksheet.
Follow these steps to enter items for a list so
that you can enter them in the future by
dragging the AutoFill handle:
1. If you’ve already entered items for the list
on your worksheet, select the items.
If you haven’t entered the items yet, skip to
2. On the File tab, and choose Options to
open the Excel Options dialog box.
3. Go to the Advanced category.
4. Click the Edit Custom Lists button (you
have to scroll down to find it).
You see the Custom Lists dialog box.
5. In the List Entries box, do one of the
If you selected the items in Step 1, click
the Import button. The items you selected
appear in the List Entries box.
If you need to enter items for the list, enter
them in the List Entries box, with one item
on each line.
6. Click the Add button.
7. Click OK.
Excel offers five number-formatting buttons on the Home tab — Accounting
Number Format, Percent Style, Comma Style, Increase Decimal, and
Decrease Decimal. Select cells with numbers in them and click one of these
buttons to change how numbers are formatted: