User Guide
You may want to hide the column (click its reference tab’s pop-up menu and
choose Hide Column). To change the placeholder name in a category row to a more
meaningful name, edit the name as you would text in any cell.
Double-click to type
a new category name.
Creating categories using values in a column
When you categorize a table using the values in a column, Numbers creates a dierent
category for each unique value in the column. The column whose value you use to
create categories is the category value column. All rows containing the same value in
the category value column are placed together in a category. The shared value is used
as the category name in the category row.
Category row
Category value column
If you change a value in the category value column, the row moves into a dierent
category if the value exists elsewhere in the category value column; otherwise, a new
category is created for the new value.
You can optionally hide a category value column, but you may want to leave the
column visible in case you need to change values in it. Also, you may not want to
edit the name in the category row. When you change a category row’s name, all the
values in the category value column for the category are replaced with the new name,
overwriting other values in the cells.
Here are ways to create categories and subcategories:
To divide a table’s rows at a particular place, choose Insert Category from the reference m
tab pop-up menu for the bottommost row in the category you want to create. For
example, to divide a 9-row table into two categories with the rst 5 rows in the rst
category, choose Insert Category from the pop-up menu for row 5.
68 Chapter 3 Using Tables