Alphabetise or sort table data in Keynote on Mac

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

Note: If the sort options aren’t available, your table might have cells merged across adjacent rows. You need to unmerge the cells to sort. Click the merged cells, then choose Format > Table > Unmerge Cells (from the Format menu at the top of your screen). If you’re not sure where the merged cells are, select the table, then choose Format > Table > Unmerge All Cells.

Text in column headers and footers isn’t sorted.

Alphabetise or sort table data

Click anywhere in the table, then move the pointer over the letter above the column by which you want to sort.
Click the arrow that appears next to the column letter, then choose a sorting option:
- Sort Ascending: Sort the data 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 cells with Boolean values (true/false) 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 — the rows just get reordered. 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.

Helpful?

Keynote User Guide for Mac

Alphabetise or sort table data in Keynote on Mac

Alphabetise or sort table data