Store Information in Row State Columns

Similar to assigning row states to rows, you can create a column that contains only row state information. A row state column stores information about whether rows are excluded, hidden, labeled, colored, marked, or selected. To designate a column as a row state column, in the Column Info window next to Data Type, select Row State.

Figure 5.4 Row States in Rows and a Row State Column 

Since row state columns store the row states, you can apply them again later. Populate row state columns by copying them from the current row states or with column formulas.

To create a row state column

1. Select Cols > New Columns.

2. Next to Data Type, select Row State.

3. Click OK.

Populate the cells with new row state information or copy existing row state information from rows.

To populate cells with new row state information

1. To populate only certain rows in the row state column, highlight those rows. Or, to populate all rows in the column, highlight the row state column.

2. Right-click and select Row States Cells.

3. Select the row state that you want to apply.

To copy existing row state information

1. To populate only certain rows in the row state column, highlight those rows. Or, to populate all rows in the column, highlight the row state column.

2. Click the star icon () beside the column name in the Columns panel.

3. Select one of the following:

Copy from Row States

Replaces the row states in the column with the row states from the rows.

Add from Row States

Adds the row states from the rows to the row state column.

Copy to Row States

Replaces the row states in the rows with the row states from the column.

Add to Row States

Adds the row states from the row state column to the row states in the rows.

Permanently Select Cells

You can save a selection in a row state column just like you save other row state characteristics (hide, exclude, color, and so on). This places a “permanent” highlight on a cell.

To permanently select cells

1. Right-click a cell and select Row States Cells > Select/Deselect.

2. Repeat this for as many cells as you would like to select.

3. To remove the highlight, right-click the cell and select Row States Cells > Select/Deselect.