Specify a Sort and a Sorting Priority for Values in a List Table

To specify a sort and a sorting priority for values in a list table, complete these steps:

Right-click a column heading in the list table, and then select either Sort Ascending or Sort Descending.
To sort additional columns in order of priority, right–click each column heading and then select either Sort Ascending or Sort Descending.

The Sort Ascending and Sort Descending Menu Options for a Table

A List Table That Has Been Sorted by the Sales Totals for Each Continent shows a list table that has been sorted by the sales totals for each continent.

A List Table That Has Been Sorted by the Sales Totals for Each Continent

A list table that has been sorted by the Continent row

If you are working with a relational list table in Edit or View mode, then you can right-click in the table and select Sort Priority. This opens the Sort Priority dialog box.

Sort Priority Menu Item in Edit Mode

Sort Priority Menu Item in View Mode

In the Sort dialog box, you can specify which item you want sorted first. You can sort multiple columns. In Sort Dialog Box with the Height and Age Columns Selected, the list table is sorted first by height and then by age.

Sort Dialog Box with the Height and Age Columns Selected

Note: The Sort Priority option is not available for list tables in a synchronized group.