Microsoft Office Tutorials and References
In Depth Information
To delete a level, click the level in the list, and then click Delete Level. Clicking the Copy
Level button enables you to put all the settings from one rule into another, saving you
some work if you need to change only one item. The Move Up and Move Down buttons,
which display an upward-pointing arrow and a downward-pointing arrow, respectively,
enable you to change a sorting level’s position in the order. Finally, clicking the Options
button displays the Sort Options dialog box, which you can use to make a sorting level
case sensitive and to change the orientation of the sort.
The default setting for Excel is to sort numbers according to their values and to sort
words in alphabetical order, but that pattern doesn’t work for some sets of values. One
example in which sorting a list of values in alphabetical order would yield incorrect
results is the months of the year. In an “alphabetical” calendar, April is the first month
and September is the last! Fortunately, Excel recognizes a number of special lists, such
as days of the week and months of the year. You can have Excel sort the contents of a
worksheet based on values in a known list; if needed, you can create your own list of
values. For example, the default lists of weekdays in Excel start with Sunday. If you keep
your business records based on a Monday–Sunday week, you can create a new list with
Monday as the first day and Sunday as the last.
To create a new list, type the list of values you want to use as your list into a contiguous
cell range, select the cells, click the File tab, and then click Options. On the Advanced
page of the Excel Options dialog box, in the General group near the bottom of the page,
click the Edit Custom Lists button to display the Custom Lists dialog box.