User guide

Sorting Rows in a Table
You can arrange values in some or all the cells in a column in ascending or descending
order. Rows containing cells being sorted are reordered. Header cells aren’t sorted.
Sorting takes into account values in hidden rows and hidden columns.
Here are ways to sort:
To sort an entire table by reordering all the cells in a column, select one of the m
column’s cells, open the Table inspector, click Table, and then choose Sort Ascending or
Sort Descending from the Edit Rows & Columns pop-up menu.
To sort part of a table by reordering some of the cells in a column, select the cells m
before choosing Sort Ascending or Sort Descending.
The following table describes how dierent 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 rst), then month
(January rst), then day (1–31)
Year (most current rst), then
month (December rst), 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
rst (1z, 1Z, a1, A1)
Values starting with text rst
(A1, a1, 1A, 1z)
Empty cells At the bottom At the bottom
Boolean (TRUE, FALSE) Below text and above an
empty cell
Above text
19 0 Chapter 8 Using Tables