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 cells in a column, choose Sort Ascending or Sort
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-
To sort only part of a table, select the rows you’d like to sort, open the Reorganize
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.
To sort the table by one column and then by another column, open the Reorganize
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
Type of data
Year (earliest first), then month
(January first), then day (1–31)
Year (most current first), then
month (December first), then
–2, –1, 0, 1, and so on
1, 0, –1, –2, and so on
Cells containing only text,
mixed with cells containing
–2, –1, 0, 1, and so on, then
Zz–Aa, then 1, 0, –1, –2, and so
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)
At the bottom
At the bottom
Boolean (TRUE, FALSE)
Below text and above an empty