Alphabetize or sort data in Numbers for iCloud
You can sort data in a table column alphabetically or by increasing or decreasing values. When you sort data in a column, all the rows of the table reorganize accordingly.
You can sort the data in a header column, but header rows in a sorted column aren’t sorted. Sorting also includes values in hidden rows and hidden columns.
Select a column, then click the down arrow on its border.
Do any of the following:
Sort the data in alphabetical order (A to Z) or by increasing numerical values: Choose Sort Ascending.
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.
Sort the data in reverse-alphabetical order (Z to A) or by decreasing numerical values: Choose Sort Descending.
Note: If your data is categorized, it’s sorted within the category groups. To sort the groups themselves, click the arrow that appears at the top of the column containing the group names, move the pointer over Sort Groups, then choose an option. To sort groups by summary row values, select the summary cell, then Control-click (on a Mac) or right-click (on a Windows computer) and choose a sort option.