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.

  1. 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.
  2. Select the columns by which to sort your worksheet.
  3. 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.
  4. Change the sort order to ascending or descending by selecting the icon on the right-hand side of each selected column.
  5. Click Apply.