Sort data in a column

You can sort data in a column alphabetically or by increasing or decreasing values. When you sort by column, the rows rearrange accordingly.

Text in column headers and footers isn’t included in the sort.

Sort data

  1. Tap the table, then tap the bar above the column containing the data that you want to sort by.

  2. Tap Sort, then tap one of the following:

    • Sort Ascending: Sorts the data in alphabetical order (A to Z) or by increasing numerical values.

    • Sort Descending: Sorts the data in reverse-alphabetical order (Z to A) or by decreasing numerical values.

In columns containing both text and numbers, ascending order sorts numbers before text (for example, 1a, 1b, 2a, a1, b1). Ascending order also places cells with Boolean values (true/false) after cells sorted alphabetically or numerically, and places blank cells at the bottom of the column.