Sorting Rows 

To sort the rows in a column, click on its column title. The sort order toggles between ascending and descending order each time you click the column title. The sort order indicator to the left of each column title (figure below) shows you which column is determining the record order (the one with a red triangle) and whether the rows are sorted in ascending or descending order (upper or lower triangle, respectively).

The set of selected row(s) remains unchanged as you change the sort order.

A column containing a multi-valued field will not be sortable and will not contain the sort order indicator.

None of the columns in a grid containing a hierarchy column will be sortable.

You can also sort a column by right-clicking on the column title and choosing Sort from the context menu, or by choosing View ® Sort By from the main menu, and then in either case, choosing Ascending or Descending from the cascading menu to specify the sort order.