Sorting by Multiple Columns Using the Advanced Sorting Options
To display the Columns dialog box with sorting options, right click a column heading, select Sort and then Show Advanced Sort Options... from the context menu.
The Columns dialog box displays a list of all columns in the table and will be expanded to show a sort configuration pane. Select the column name and then click the
Add to sorting list button (

). Once columns have been added, you may arrange the sort order using the controls below the list or by dragging the column name to the desired spot in the list; see
Changing Column Order and Display for information on the Columns dialog box controls. Set the sort type by clicking the button on the left to get the proper sort direction.