User Guide
Chapter 3 Using Tables 69
To place a range of adjacent or nonadjacent rows into a category, select the rows and m
then choose “Create Category from Selected Rows” from the reference tab’s pop-up
menu for one of the selected rows.
To categorize rows with the same value in a particular column, choose “Categorize by m
This Column” from the reference tab pop-up menu for the column. When a value in the
column changes, its row is placed in a dierent category based on its new cell value.
You can also use the Reorganize window. Click in the table and then click Reorganize
in the toolbar or choose Show More Options from a reference tab’s pop-up menu to
open the Reorganize window. Click the Categories disclosure triangle to reveal the
categorizing controls. From the rst pop-up menu, choose the name of the column
you want to use as a category value column.
Choose the name of the column
you want to use as a category
value column.
Table categories are created based on unique values in the chosen column.
Category row
Category value column










