Selecting Data in a Table

Select Cells in a Table

Use any of the following methods to select one or more cells in a table:
  • To select a single cell, click the cell.
  • To select multiple cells, click and drag the cursor across the cells that you want to select.
Note: When you double-click a cell, the cell becomes editable.

Select Variables in a Table

Use any of the following methods to select one or more variables in a table:
  • To select a single variable, click on the header for the variable that you want to select. The header and entire column are highlighted.
  • To select multiple variables, press and hold the CTRL key and select the variables that you want. To select a block of contiguous variables, select the first variable in the block, press the Shift key, and then select the last variable in the block.
  • To select a large number of variables, it might be easier to select a few variables that you don't want and then invert your selection. To invert a selection:
    1. In the data table, select one or more variables that you don't want selected.
    2. Right-click and choose Invert Selection from the pop-up menu. All currently selected variables become deselected, and all deselected variables become selected.

Select Observations in a Table

Use any of the following methods to select one or more observations in a table:
  • To select a single observation, click on the header for the row that you want to select. The header and entire row are highlighted.
  • To select multiple observations, press and hold the CTRL key, and select the rows that you want. To select a block of contiguous observations, select the first row in the block, press the Shift key, and then select the last row in the block.
    To select all observations, click the table and then press CTRL-A.
  • To select a large number of observations, it might be easier to select a few observations that you don't want and then invert your selection. To invert a selection:
    1. In the data table, select one or more observations that you don't want selected.
    2. Right-click and choose Invert Selection from the pop-up menu. All currently selected observations become deselected, and all deselected observations become selected.
Note: When selecting observations, you might want to sort the data table first so the observations appear in a particular order. For instructions, see Sorting a Table.