Page 46 - Excel Data Analysis

03 537547 Ch02.qxd 3/4/03 11:46 AM Page 32

EXCEL DATA ANALYSIS

CREATE A CUSTOM SORT

ou can create custom sort orders to sort your lists in following custom sort order, Excel sorts the list using the
Excel. This is a great feature when you want to sort order of the words in the list. Therefore, Excel sorts all
Y your list by something other than alphabetically or records that contain First to the top, followed by those
numerically. See the section "Sort a List" for more containing Second:
information. A custom sort provides a great data analysis First, Second, Third, Fourth, Fifth, Sixth
tool, as you can sort a large list of data in a specific order,
such as by department or month. For example, if your list Although you perform your custom sort order using the
contains a column of month names, you probably want to Sort dialog box, before you can perform the sort, you must
sort based upon the order of the months in the year, not first create a custom sort order list to make it available for
alphabetically by month name. For more on lists, see the all workbooks that you edit.
section "Create a List."
You can create your own custom sort orders using your
Excel provides four default custom sort lists for sorting days own custom lists. You create sort order lists in the Custom
of the week and month names. You can use these sort Lists tab of the Options dialog box. After you create a
orders or create your own unique lists, such as employee custom list of words, you can select it at any point in the
names, department locations, seasons, and so on. When Sort Options dialog box.
you select a custom sort order, Excel sorts your list based
upon the order you specify. For example, if you define the

CREATE A CUSTOM SORT

CREATE A SORT ORDER ■ The Options dialog box ¤ Click the Custom Lists
displays. tab.
⁄ Click Tools ➪ Options.

32