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 Lower Triangular Area.

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

Lower Triangular Area

To select random rows

1.	Select Rows > Row Selection > Select Randomly.

2.	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

1.	Select Rows > Row Selection > Select Dominant.

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

3.	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

1.	Select Rows > Row Selection > Name Selection in Column.

2.	Type a column name.

3.	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 Unselected or Deselected 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

1.	Select Rows > Row Selection.

2.	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.

Locate Next and Previously Selected Rows

You can locate the next selected row after the current row and cause it to flash by selecting Rows > Next Selected. Similarly, you can locate the previously selected row before the current row and cause it to flash by selecting Rows > Previous Selected.

Each time you select Rows > Next Selected or Rows > Previous Selected, the next or previously selected row is found and flashes. A beep signals when the last selected row is located.

You might want to use this feature when you have selected rows intermittently in a large data set and want to look through the selected rows in the data table.

Example of Locating Next and Previously Selected Rows

1.	Open the Diamonds Data.jmp sample data table.

2.	Select Analyze > Fit Y by X.

3.	Select Carat Weight and click Y, Response.

4.	Select Price and click X, Factor.

Click OK.

6.	Select Tools > Lasso.

If you cannot see the menu bar, place your mouse pointer over the blue bar below the title bar to reveal it.

7.	Lasso some of the points near the 10,000 dollar price at the bottom of the plot. See Points Selected.

8.	In the data table, select Rows > Next Selected (or you can press the F7 key).

You can easily navigate through the selected rows to see the data for each.

Points Selected