Using JMP > Enter and Edit Your Data > Select Columns in Data Tables
Publication date: 03/23/2021

Select Columns in Data Tables

There are several ways to select columns:

Select columns in the data table itself. See How to Select Columns.

In a data table that has many columns, select columns by attributes, properties, and statistics in the Columns Viewer. See Select Columns in the JMP Columns Viewer.

Find the next or previously selected column. See Locate Next and Previously Selected Columns in Data Tables.

How to Select Columns

Choose one of several methods for selecting columns in a data table.

To select one entire column

In the data grid, click in the empty space around the column name.


In the Columns panel, click the column name.

To select a specific column number

1. Select Cols > Column Selection > Go to.

2. Enter the column number or name and click OK.

To select multiple columns

For continuous selection:

Click and drag the cursor over the column name.

Press Shift and click the first and last columns of the desired range.

Press Shift and press the left or right arrow key.

For columns that are not next to each other:

Press Ctrl and click each column.

To select or deselect all columns

Press Shift and click the upper triangular area in the upper left corner of the data grid to select. Click again in the same area to deselect all columns.

Figure 4.10 Upper Triangular Area 

Upper Triangular Area

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

To invert the column selection

Select Cols > Column Selection > Invert Column Selection. Selects any column that is currently deselected and deselects any column that is currently selected.

Want more information? Have questions? Get answers in the JMP User Community (