Sort Multiple Columns
You can choose to have a worksheet sorted by multiple columns in any given
order.
Follow these steps to sort a worksheet by multiple columns.
-
Select the Sort icon in the upper left corner of your
worksheet.
Note
You can also sort multiple columns by selecting each column header and
clicking the sort icon in that column. The worksheet will be sorted in the
order that you select the columns to be sorted.
-
Select the columns by which to sort your worksheet.
-
Drag and drop the columns on the right-hand side to determine the sorting
order. The first column will be the primary column used to sort the worksheet
and subsequent columns will be used to sort equal values in the previous
column.
-
Change the sort order to ascending or descending by selecting the icon on the
right-hand side of each selected column.
-
Click Apply.