Sort data within columns

In the Sort dialog box, enter the columns to sort and the columns to sort by.

  1. In Columns to sort, enter the columns that contain the values to sort.
  2. Under Columns to sort by, enter the columns that contain the values to sort by and indicated how you want to sort:
    • Increasing: Sort values in increasing order, for example, 1, 2, 3 or A, B, C.
    • Decreasing: Sort values in decreasing order, for example, 3, 2, 1, or C, B, A.
    Data are sorted by the first column to sort by, then those results are sorted by the next column to sort by, and so on. For an example of sorting by multiple columns, go to Example of sorting columns.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy