Microsoft Office Tutorials and References
In Depth Information
Create your own
SORT OR AUTOFILL
In Excel, you can sort your data alphabetically, by
days of the week, or by months of the year. See
Chapter 4 to learn more about sorting your data. You
can also automatically fill cells with the days of the
week or months of the year by using Excel’s AutoFill
feature. See Task # 3 to learn more about AutoFill.
If you have a data series you use often, you can
create your own custom list and use it to fill cells
automatically or to sort a list. For example, you
collect data by region and you always list the data
in the following order: North East, South East, North
Central, South Central, North West, and South West.
You can create a custom list that enables you to
AutoFill and sort based on your list.
Use the Custom List dialog box to create your custom
list. You can type your list into the Custom List dialog
box or import your list from cells in your worksheet.
You access your custom list the same way you would
any other custom list or AutoFill.
Click and drag to select the cells
with which you want to create
your custom list.
Click the Office button.
A menu appears.
Click Excel Options.
The Excel Options dialog box
Click the Edit Custom Lists