Use the right-click menu in the grid to easily sort the table based on a single
column in ascending or descending order.
Reorder the rows of a table such that the values in a particular column are in
ascending or descending order.
To sort rows within the grid:
-
In the Grid view of an open table or worksheet, right-click a cell in the
column on which you want to base the sort.
-
From the menu, select one of the following:
Option | Description |
---|
up |
Sorts the rows in the table such that the values in the column are
in ascending order. |
up with N/As at end |
Sorts the rows in the table such that the values in the column are
in ascending order. Rows with N/A (missing) values are sorted such that
they are located at the bottom of the worksheet instead of at the
top. |
down |
Sorts the rows in the table such that the values in the column are
in descending order. |
down with N/As at beginning |
Sorts the rows in the table such that the values in the column are
in descending order. Rows with N/A (missing) values are sorted such that
they are located at the top of the worksheet instead of at the
bottom. |
The Trillion-Row Spreadsheet sorts the table based on the column in ascending
or descending order and adds the sort operation to the Analysis
Timeline.