You can sort data in a column alphabetically or by increasing or decreasing values. When you sort by column, the rows of the table reorganize accordingly.
Text in column headers and footers isn’t sorted, but values in hidden rows and hidden columns are.
Tap the table, then tap the column letter above the column containing the data by which you want to sort.
All the rows in the table are reordered according to the sorting of this column.
Tap Sort, then tap either of the following:
Sort Ascending: Sort the table rows in alphabetical order (A to Z) or by increasing numerical values based on the data in the selected column.
Sort Descending: Sort the table rows in reverse-alphabetical order (Z to A) or by decreasing numerical values based on the data in the selected column.
In columns containing both text and numbers, ascending order sorts by numbers before text (for example, 1a, 1b, 2a, a1, b1). Ascending order also places Boolean (true/false) cells after cells sorted alphabetically or numerically, and places blank cells at the bottom of the column.