Skip to main content

Sort a Worksheet using advanced multi-level sorting

Bally
  • Updated
Advanced sorting in Worksheet allows you to organise data using multiple columns with independent sort directions. This provides greater control when working with large or complex datasets, such as panel systems.
Sorting behavior is aligned with CET Calculation, ensuring a consistent experience across both tools. 

Note: This feature is available from version 2026.1

With advanced sorting, you can:
  • Sort by multiple columns in a defined order
  • Assign a different sort direction (ascending or descending) to each column
  • Retain sorting automatically when importing data from CET via XML
  • Save and reuse sorting configurations 

Multi-level sorting

  • Sorting is applied in the order columns are listed
  • The first column acts as the primary sort
  • Each additional column acts as a nested sub-sort

Independent sort direction

  • Each column has its own ascending or descending setting
  • There is no longer a global sort direction

How sort a Worksheet

To apply sorting to a Worksheet:

  1. Right click in the column header and select Sort > Multiple columns. 
     
  2. Arrange the columns in the desired order using:
    • Top
    • Move Up
    • Move Down
    • Bottom
       

  3. Select the columns you want to include in the sort.

     

  4. Set the sort direction for each column using the arrow toggle under the column Sort (ascending/descending) next to the column name.
     
  5. Apply the sort by clicking OK. 

Manage sorting options

Save and reuse a sort configuration

  1. Right click in the column header and select Sort > Sort settings > Manage sort settings. 
     
  2. In the Manage Sort Settings window click on New...
     
  3. Give the setting a unique name and click OK.  
     
  4. Use the steps under the heading How to sort a Worksheet to create the sort order. 
     
  5. Select OK to save the configuration.
     
  6. To use the configuration in other Worksheets right click in the column header and go to Sort > Sort settings and the sort configuration will be visible in the list. 

Additional behavior

  • Importing data from CET via XML retains the original sort order and direction automatically
  • Subtotals can still be applied based on the primary sort column
  • Applying a sort removes any existing subtotals in the worksheet (with a warning shown)

 

Related articles