Apple Numbers '09 Manual de usuario descargar pdf (Pagina 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 ltering controls.

4 Choose the column whose values you want to use to create lter criteria.

5 Use the remaining controls to dene the column value for rows you want to show.

6 To use additional lter criteria, click the Add button (+) to dene 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 ltering rows. To stop

ltering 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 dierent 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

1 2 ... 64 65 66 67 68 69 70 71 72 73 74 ... 92 93

Sin comentarios

Apple Numbers '09 Manual de usuario Pagina 69