-
Click
on the Worksheet toolbar.
-
In the Multiple Column Sort dialog, select the check boxes beside the columns you want to sort by.
Note: The Sort folder may be changed in the Preferences dialog.
The Save button will enable saving a sort order for later use within the worksheet.
Properties of the method to be saved:
- Criteria used
- Sort order: Primary, 2nd, 3rd, etc.
- Ascending/Descending
- Insert Subtotals after each unique value of the primary sort field
- Subtotal by Area Tag (where applicable).
A Save dialog will appear when Save is clicked, allowing the user to save the sort Setting.
The Load button will enable loading a previously saved sort order for later use within the worksheet.
An Open dialog will appear when Load is clicked, allowing the user to load the save sort Setting.
The properties of the loaded sort Setting apply within the Multiple Column Sort dialog.
Once the properties are applied, the OK button is enabled; clicking it will then apply the sort Setting to the current worksheet.