Sorting List Columns

You can sort the records in a list by the values in one or more columns. For example, you can sort accounts to appear alphabetically by name (by sorting on the Name column). You can use an advanced sort to sort by up to three columns at once. For example, you might want to sort the accounts by name, then by current volume of sales, and then by city.

The active sort order of a column is designated in the column header. A dark arrow pointing up means the values in the column are sorted in ascending order. A dark arrow pointing down means the values in the column are sorted in descending order.

Sorting a Single List Column

You can sort data a single column in ascending order and in descending order.

To sort a single column

In a list, click the column header of the column that you want to sort.
Click Sort.

The column is sorted in ascending or descending order.
Click the column header again.
Click Sort.

The column is sorted in the opposite order.

Performing an Advanced Sort in Lists

You use the Sort Order dialog box to perform an advanced sort.

To perform an advanced sort in a list

In a list, click the Cogwheel icon, and then click Advanced Sort.

The Sort Order dialog box appears.
From the drop-down list for the Sort By field, select the first column to sort by.
From the drop-down list for the first Then By field, select the second column to sort by.
From the drop-down list for the second Then By field, select the third column to sort by.
Use the Ascending and Descending option buttons to define the sort order for each column you select for the advanced sort.
Click OK.

The columns are sorted in the order you specify.