|
Sort dialog box |
|
Use this dialog box to specify the context and extent for sorting information in the currently active worksheet. This dialog box can take one of two forms depending on the subject of the operation, as follows:
| 1. | If the Sort command is carried when one or more rows are selected on the currently active worksheet, the software assumes you want to sort the columns in the worksheet and the dialog displays under the title Sort Columns. |
| 2. | If the Sort command is carried when one or more columns are selected on the currently active worksheet, the software assumes you want to sort the rows in the worksheet and the dialog displays under the title Sort Rows. |
Sort Type
Select one of the following options to specify the type of the sort operation.
Select this option to specify you want to sort the data in coordination, ordered according to the selected key numbers (Key Number). This option affects the position of all data in the currently active worksheet.
Select this option to specify you want to sort data independently, as indicated by the selected sort numbers (Sort Number). This option restricts the operation to independent sorts within the currently active worksheet, so that the final order of items in a sorted column (or row) does not affect the order of items in other columns (or rows).
Key | Sort Information
Key Number (Coordinated Sort)
Specifies key order. Items are sorted according to the order of the keys. You can specify as many keys as you require by selecting one of the available row or column numbers in the Row | Column Number box.
 | You can choose to ignore a listed key by setting the corresponding Row | Column Number option to None. However, you are required to specify at least one key with a row or column number other than None for the operation to proceed. |
Sort Number (Independent Sort)
Specifies the data to sort. Formulate as many sort operations as you require by selecting one of the available row or column numbers in the Row | Column Number box for each Sort Number value.
| You can choose to ignore a listed sort number by setting the corresponding Row | Column Number option to None. However, you are required to specify at least one sort number with a row or column number other than None for the operation to proceed. |
Specifies the row or column number to associate with the currently selected key or sort number.
| · | In Coordinated Sorts |
Specifies the row or column number to associate with the currently selected key number. Select one of the listed row or column numbers, or select None if you want the software to ignore the currently selected key.
| · | In Independent Sorts |
Specifies the row or column number to associate with the currently selected sort number. Select one of the listed row or column numbers, or select None if you want the software to ignore the currently selected sort number.
Specifies the sort order of the currently selected key or sort number.
| · | In Coordinated Sorts |
Select either Ascending or Descending for the currently selected key number.
 | You can select this option independently for each of the listed numbers. |
| · | In Independent Sorts |
Select either Ascending or Descending for the currently selected sort number.
| You can select this option independently for each of the listed sort numbers. |
Check this box to specify you want to take into consideration alphabetic case when sorting.
| · | In Coordinated Sorts |
Specifies ordering of the currently selected key (Key Number) takes into consideration alphabetic case.
| You can select this option independently for each of the listed key numbers. |
| · | In Independent Sorts |
Specifies ordering of the currently selected sort (Sort Number) takes into consideration alphabetic case.
| You can select this option independently for each of the listed sort numbers. |
Closes the dialog box and carries out this operation.
Closes the dialog box without carrying out this operation.
Sponsored
Try Predictive Systems Lab
Need Help?
Contact support