Owner manual

Chapter 8 Creating Tables 181
3 Click the Numbers button.
4 Use the Sort Column buttons to indicate whether you want to sort in ascending or
descending order.
The following table describes how different types of data are sorted in ascending or
descending order.
Sort selected column cells in
ascending order. Rows
containing the cells will be
reordered.
Sort selected column
cells in descending order.
Rows containing the cells
will be reordered.
Type of data Ascending order Descending order
Text aA–zZ Zz–Aa
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) Above text Below text