Sorting data

You can sort the data in a range, in ascending or descending order, based on the values in one or more columns that you specify. For English, the sort order is alphabetical. The sort order for German, Japanese, and French is controlled by the locale convention. For other languages, the order is controlled by Unicode values only.


  1. Select the range where you want to sort data.
    Note: If you select a range that contains column labels, the sorting begins with the row after the column label (headings).
  2. Click Data > Sort, and select Ascending or Descending, depending on which order you want.
  3. To sort by multiple columns, click Add a sort column for each column that you want to add.