User Guide
Chapter 3 Using Tables 65
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 m
Sort Now.
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 dierent 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
Filtering Rows in a Table
You can hide rows in a table that don’t contain the values you specify.
When you sort table cells, values in hidden rows are taken into account.
To specify criteria for rows you want to show:
1 Click in the table.
2 Click Reorganize in the toolbar or choose Show More Options from a reference tab’s
pop-up menu to open the Reorganize window.
3 Click the Filter disclosure triangle to reveal the ltering controls.