Select Rows

To select one entire row

•

Click in the empty space that contains the row number.

To select a specific row number

•

Select Rows > Row Selection > Go to Row and type in the desired row number.

To select multiple rows

•

For continuous selection:

–

Click and drag the cursor over the row numbers.

–

Hold down the Shift key and click the first and last rows of the desired range.

–

Hold down the Shift key and press the up or down arrow key.

•

For discontiguous selection:

–

Hold down the Ctrl key and click on each row.

To select or deselect all rows

•

To select all rows, select Rows > Row Selection > Select All Rows.

•

To deselect all rows, select Rows > Clear Row States.

•

Hold down the Shift key and click the lower triangular area in the upper left corner of the data grid to select. Click again in the same area to deselect all rows. See Figure 4.7.

•

To clear all highlighted areas in the data table, press the Esc key.

Figure 4.7 Lower Triangular Area

To select random rows

Select Rows > Row Selection > Select Randomly.

You can randomly select either a specific number of rows, or a proportion of the total number of rows:

–

Enter a whole number to select that number of rows.

–

Enter a value between 0 and 1 to select that proportion of rows.

For example, enter 10 to select 10 rows. Enter 0.1 to select 10% of the rows.

To invert the row selection

•

Select Rows > Row Selection > Invert Row Selection.

To select dominant rows

Select Rows > Row Selection > Select Dominant.

Choose the column(s) whose values you want to use to determine dominancy.

Select the high or low values to dominate by for each column.

Click OK.

Note the following about dominant values and rows:

•

A value is dominant over another value if it is higher or lower (based on your specification).

•

The Select Dominant option selects each row that is not dominated by any other row. A row dominates another row only if all of its values are dominating the other row’s values.

•

The resultant set of rows is called the Pareto Frontier.

To save the current row selection in a new column

Select Rows > Row Selection > Name Selection in Column.

Type a column name.

Label the selected and deselected rows.

Click OK.

Tip: If you repeat this process after creating the new column and indicate the same column name, the original column is overwritten. Changes that you made in the data table to Selected or Unselected values are lost. Avoid overwriting those values by clearing the corresponding box in the Name Selection in Column window. For example, to avoid overwriting the Unselected values, clear the Unselected box.

To select excluded, hidden, or labeled rows

Select Rows > Row Selection.

Select from the following options:

–

Select Excluded

–

Select Hidden

–

Select Labeled

Note: For details about excluded, hidden, or labeled rows, see Assign Characteristics to Rows and Columns.

To select rows that contain duplicate values

Select Rows > Row Selection > Select Duplicate Rows.

All duplicate rows except for the first are selected. If no columns are selected, duplicate rows will be selected using all the columns.

If columns are selected, duplicate values are found in the rows of those columns.

The match is case sensitive.