User Guide

To show rows hidden immediately above a row or columns hidden immediately m
to the left of a column, click the reference tab for the row or column and then
choose “Unhide Rows row numbers“ or “Unhide Columns column letters” from the
pop-up menu.
To show rows or columns hidden in a selected range of rows or columns, select the m
range and then choose Unhide Selected Rows from the pop-up menu of any of the
selected rows or columns.
Rows or columns that are hidden in Numbers tables are removed when the tables are
copied into other iWork applications.
Rows and columns that contain merged cells can’t be hidden.
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 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.
64 Chapter 3 Using Tables