Alphabetize or sort table data in Numbers on Mac
You can sort some or all data in a table alphabetically or by increasing or decreasing values. When you sort by a column, the rows of the table rearrange accordingly.
Note: If the sort options arent available, your table might have cells merged across adjacent rows. You need to unmerge the cells to sort. Click the merged cells, then choose Table > UnmergeCells (from the Table menu at the top of your screen). If youre not sure where the merged cells are, selectthetable, then choose Table > Unmerge All Cells.
Text in column headers and footers isnt sorted, but values in hidden rows and hidden columns are.
Alphabetize or sort by ascending or descending values
- 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 (AtoZ) or by increasing numerical values.
- Sort Descending: Sort the data in reversealphabetical order (ZtoA) or by decreasing numerical values.
Note: If your data is categorized, its sorted within the category groups. To sort the groups themselves, move the pointer over the column with the group names and click the arrow that appears. Move the pointer over Sort Groups, then choose an option. To sort groups by summary row values, you can also click the arrow next to the column letter, move the pointer over Sort Summaries, then choose an option.
You can also sort the whole table. Select the table, then in the Sort tab of the Format
sidebar, choose one or more columns to sort, then choose a sorting option.
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.
Create a sorting rule
You can sort a table by creating sorting rules, which allow you to specify multiple criteria for sorting and their order of importance. For example, you can sort a list of swimmers by age and then by their time in an event. The result orders the swimmers at each age level according to their speed.
Note: You cant sort rows with merged cells.
- Select a table to sort, or select just specific rows in a column to sort.
- In the Organize
sidebar, click the Sort tab.
- Click the pop-up menu in the sidebar and choose Sort Entire Table or Sort Selected Rows.
- Click Add a Column.
- Choose a column to sort by, then click the pop-up menu in the rule and choose Ascending or Descending.
To add more rules, click Add a Column.
Sorting rules are applied in the order they appear in the sidebar.
- To reorder the rules, move the pointer over the rule, drag
, then click Sort Now.
Delete a sorting rule
If you dont need a rule, you can delete it.
- Click the table.
- In the Organize
sidebar, click the Sort tab, move the pointer over a rule, then click