Sort Column Order within a Spreadsheet
See Also
This dialog can be used to sort the current display order of the columns within a spreadsheet based on a specified criteria.

Sort Type

This specifies the criterion use to sort the column order.
By values in a Row Use the numerical or text values within a specified row in the spreadsheet.
By Column Names Use the alphabetical order of the names.
By Column Names Use the order that the columns were created in. Use this item to put a spreadsheet back into the order it was originally created in.
By Names within Type Within each column type (factors, variates, text) use the alphabetical order of the names. Thus factors will come first, followed by variates and then finally text columns.

Using Row Number

The row number within the spreadsheet containing the data to sort on.

Ignore Case

Specifies whether case should be ignored when sorting on text items. If text case is ignored then upper and lower case letters are equivalent.

Sort Direction

Selects whether the data is sorted into ascending or descending order. Missing values are considered to be "less than" other values, so will be moved to the beginning when sorted in ascending order and the end when sorted in descending order.

OK

Use the specified criterion to sort the columns into a new order and close the dialog.

Cancel

Close the dialog without making any changes.

See Also