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 bar above the column containing the data that you want to sort by.
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.