User Guide
Chapter 3 Using Tables 67
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 “Dening Table Categories and Subcategories” on
page 67
Remove categories “Removing Table Categories and
Subcategories” on page 72
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 72
Dening 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.
Creating categories manually
When you create categories by manually inserting a category row, a new column
(the category value column) is added to the table to display unique placeholder
values for each category. The placeholder value is used in the category row to
identify the category.
Category value
column