Pages User Guide for iPad
- Welcome
- Copyright
Alphabetize or sort table data in Pages on iPad
You can sort column data alphabetically or by increasing or decreasing values. When you sort by column, the rows of the table rearrange accordingly.
Important: To sort a table with cells that are merged across adjacent rows, you need to unmerge the cells first. Tap the table, tap the merged cells, then tap Unmerge.
Text in column headers and footers isn’t sorted.
Note: The tasks below apply to a table you add to your page. They don’t apply to a page you formatted into columns.
Alphabetize or sort table data
Tap the table, then tap the column letter above the column containing the data by which you want to sort.
Tap Sort, then tap one of the following:
Sort Ascending: Sort the data, either in alphabetical order (A to Z) or by increasing numerical values.
Sort Descending: Sort 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 Boolean (true/false) cells after cells sorted alphabetically or numerically, and places blank cells at the bottom of the column.
Tip: Table columns don’t sort independently from each other—all the cells in a row stay together when you sort a column. If you want to sort a column separately, first sort the column, then copy all the cells in that column. Then Undo the sort (to revert to the previous table sort order) and paste the copied cells back into the column.