Microsoft Office Tutorials and References
In Depth Information
Sorting a list by one criterion, such as age, arranges
your records for easy scanning. You can also sort
by multiple criteria — a sort within a sort. When
possible, sort first by a discrete category such as
gender, community, region, or department. That way,
subsequent sorts apply to the multiple values
contained within each category.
For example, after sorting your customer records by
community, you could sort them by gender to display
the communities in which the men and women live.
Sorting by a third column, income, would then show
how men’s and women’s incomes differ in each
With your data sorted in this way, you can create
subtotals, averages, and counts at every break in
a category — that is, for all people in a specific
community, for men and women in that community,
and so on.
You define all sorts in the Sort dialog box. Ascending
and descending are not your only choices. In the
Sort dialog box, you can click Options to specify a
custom order. For example, you could order months
chronologically from January to December instead of
alphabetically from April to November, which, in most
cases, would not be useful.
Click in a cell in your list.
Click the Data tab.
l The Sort dialog box appears.
Click here and select the column
by which you want to sort.
Click here and select Values.
Click here and select a sort order.
Click the Add Level button.