-
Click
on the Worksheet toolbar.
-
In the Multiple Column Sort dialog, select the checkboxes beside the columns you want to sort by. You can also Select All or Clear All of the columns. Only columns that are displayed in the worksheet are available.
-
By highlighting a column name (such as Part Number) and using the Move Up, Move Down, Top or Bottom arrows, move the column up or down in the sorting order.
This will adjust the rank or order of your sort. The first column checked will be used as the primary sort field. -
Choose either sort order:
Ascending - sorting from 0 to 9, then A to Z
Descending - sorting from Z to A, 9 to 0 -
If you want to Insert subtotals after each unique value of the primary sort field, check the box.
-
Click OK to execute the sort.