Select rows based on cell location

Select rows in the table or worksheet based on the location of the row in the grid.

You can quickly perform a basic row selection directly from a table or worksheet within the grid by right-clicking any cell and then choosing a selection option in the menu. These options use the location of the selected cell as the basis for the row selection.

To select rows based on cell location:

  1. In the Grid view of an open table or worksheet, right-click the cell on which you want to base the row selection and point to Quick select rows.
    The Trillion-Row Spreadsheet displays a list of selection options.

  2. Click the desired selection option.
    Available options include the following:
    Selection commandDescription
    Before this one Rows listed before the row containing the cell you right-clicked are selected.
    Up to and including this one Rows listed before, and including, the row containing the cell you right-clicked are selected.
    Starting with this one Rows listed after, and including, the row containing the cell you right-clicked are selected.
    After this one Rows listed after the row containing the cell you right-clicked are selected.
    Other than this one (remove row) All rows other than the row containing the cell you right-clicked are selected.
    Only this one Only the row containing the cell you right-clicked is selected.

    The Trillion-Row Spreadsheet displays the results of your selection in the grid and adds the select operation to the Analysis Timeline.