Apple Numbers '09 - Manual (Page 70)

Category rows have special characteristics that help you manage your categories.
You can add new categories, remove categories, and perform other operations by Â
using the cell reference pop-up menu for a category row. Choosing Expand All or
Collapse All expands or collapses all categories at the level of the row from which
you chose the command.
Cell reference
pop-up menu for this
category row
You can display automatically calculated values (such as subtotals and row count) in Â
category row cells.
Calculated row count
To learn how to Go to
Create categories and subcategories “Defining Table Categories and Subcategories” on
page 70
Remove categories “Removing Table Categories and
Subcategories” on page 75
Add or remove rows from categories, display
automatically computed values in cells of a
category row, move a category, change the level
of a category, collapse or expand category rows,
and perform other category management tasks “Managing Table Categories and
Subcategories” on page 75
Defining Table Categories and Subcategories
You can have Numbers create categories or subcategories based on values in one or
more columns in the table. Or you can assemble rows into categories by manually
inserting category rows between table rows. You can create categories based on
adjacent or nonadjacent selected table rows.
70 Chapter 3 Using Tables