Saving sort settings

Sort Settings will, by default, be saved to a specific, auto-generated folder on the user's system.  The new folder name will be Sorts, located within the CAP folder, and located at the same level as the Projects, Exports, and CoverPages folders.  You may navigate to any folder to save the Sort Setting, using the standard Windows Save dialog.  Filename will have a .sort file extension.

1. Click on the Worksheet toolbar.
   
   

2. 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.