Numbers - Sorting Rows in a Table

Here are ways to sort:
To sort an entire table by reordering cells in a column, choose Sort Ascending or Sort

m

Descending from the pop-up menu for the column’s reference tab.
You can also click in a table and then click Reorganize in the toolbar or choose Show
More Options from a reference tab’s pop-up menu to open the Reorganize window.
Click the Sort disclosure triangle to reveal the sort controls. Choose “Sort entire table”
from the pop-up menu, and then choose a column and sort order from the other pop-
up menus.

To sort only part of a table, select the rows you’d like to sort, open the Reorganize

m

window, and choose “Sort selected rows” from the pop-up menu. Then choose a
column to sort by and a sort order from the other pop-up menus.
To re-sort values after changing them, open the Reorganize window and click Sort Now.

m

To sort the table by one column and then by another column, open the Reorganize

m

window and choose an option from the three pop-up menus. Then click the Add
button (+) and choose options for the second sort.
To apply additional sort criteria, click the Add button (+) again.

The following table describes how different types of data are sorted in ascending or
descending order.

Type of data

Ascending order

Descending order

Text

aA–zZ

Zz–Aa

Dates

Year (earliest first), then month
(January first), then day (1–31)

Year (most current first), then
month (December first), then
day (31–1)

Numbers

–2, –1, 0, 1, and so on

1, 0, –1, –2, and so on

Cells containing only text,
mixed with cells containing
only numbers

–2, –1, 0, 1, and so on, then
aA–zZ

Zz–Aa, then 1, 0, –1, –2, and so
on

Cells containing a mixture of
text and numbers

Values starting with numbers
first (1z, 1Z, a1, A1)

Values starting with text first
(A1, a1, 1A, 1z)

Empty cells

At the bottom

At the bottom

Boolean (TRUE, FALSE)

Below text and above an empty
cell

Above text

68

Chapter 3

Using Tables