Use the options in the Sort tab to specify how you want to sort your tables. For more information, see Sorting tables.

If there is more than one cell item in the table, the first cell item is always used to test the sort condition. In most tables this is likely to be the Counts cell item. To sort tables based on another cell item, use the Cell Contents tab to move the cell item so that it appears first in the table.

To display this tab, select the table you want to sort in the Tables pane, then choose Tables > Properties from the menu and click the Sort tab.

Contains a list of all the columns in the table. Select a column to use to sort the rows of the table. The default is Not sorted (that is, the rows are displayed in the order in which they appear in the variable).

You can also choose to sort rows in ascending or descending order. The default is descending order.

Contains a list of all the rows in the table. Select a row to use to sort the columns of the table. The default is Not sorted (that is, the columns are displayed in the order in which they appear in the variable).

You can also choose to sort columns in ascending or descending order. The default is descending order.

You cannot apply sort options to multiple tables, as the options available depend on the rows and columns in individual tables.

Sets all the properties for the selected tables to their default values. This affects all the properties in the dialog, not only the ones on the current tab.