Apple Numbers '09 - Manual (Page 69)

Chapter 3 Using Tables 69
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 filtering controls.
4 Choose the column whose values you want to use to create filter criteria.
5 Use the remaining controls to define the column value for rows you want to show.
6 To use additional filter criteria, click the Add button (+) to define each one you want
to add.
If you choose “is in the top n values” or “is in the bottom n values,” all values matching
the top or bottom n will be shown, which may be more than n.
Note: You can’t add any new rows to the table until you stop filtering rows. To stop
filtering rows in the table, deselect “Show rows that match the following” in the
Reorganize window.
Creating Table Categories
You can organize a table into categories. You can create categories by selecting
particular rows for a category, or you can set Numbers to create categories and
subcategories automatically using the value in one or more columns of the table
(category value columns). When you use category value columns, changing values in
them may cause rows to move into different categories.
Each category or subcategory is displayed with a category row above it. You click the
disclosure triangle near the left edge of the category row to view or hide (expand or
collapse) the category.
Category row for office furniture
Category row for patio furniture
Category row for library furniture