Page Comparison

...

...

1. Open the worksheet in your workbook you want to sort. 
    
2. Select Select "Edit" from  from the main menu and then select select "Sort" or  or click on the 'Sort' icon. The dialog 'Apply Sorting' opens. 
    or 
3. Activate the checkbox, if you want to have the result of your sorting in a new sheet. 
    
4. Select the column you want to sort from the drop-down down 'Sort By'. The drop-down 'Select Option' appears.
    
5. Select the sorting option from the drop-down down 'Select Option'. 
    
6. If needed, click on "+" to  to sort more columns. A new line for sorting another column opens. 
   INFO: You can delete any sorting for a column by clicking "-". 
    
7. Repeat step 4 and 5 for each new column sorting. 
   INFO: The order in which the sorting is done is analogous to the order in the dialog, e.g. first sorting is by column A and then after column B, if column A has the same values. 
    
8. If needed, limit the number of results returned by entering a maximum number. 
   INFO: Leaving no entry gets all records.
    
9. Confirm with with "Sort Sheet". The resulting and sorted sheet is displayed. Columns, which are sorted are marked. Sorting is finished.
    

Revising Sorted Data

To revise sorted data:

1. Open the worksheet in your workbook, which has already sorted data. 
   Image Modified 

...

1. Select "Edit"

...

1.  from the main menu and then

...

1. select "Sort"

...

1.  or click on

...

1. the 'Sort'

...

1.  icon. The dialog 'Apply Sorting' opens.
   Image Modified or Image Modified
2. Change the content

...

1. of 'Sort By'

...

1.  and 'Select Option'

...

1.  for the already sorted lines. 
   INFO: The order in which the sorting is done is analogous to the order in the dialog, e.g. first sorting is by column A and then after column B, if column A has the same values. 
   Image Modified 
2. If needed, click

...

1. on "+"

...

1.  to sort more columns. A new line for sorting another column opens. 
   INFO: You can delete any sorting for a column by clicking "-". 
   Image Modified 
2. If needed, limit the number of results returned by entering a maximum number. 
   INFO: Leaving no entry gets all records.
   Image Modified 
3. Confirm

...

1. with "Update Sort". The resulting and sorted sheet is displayed. Columns, which are sorted are marked. Sorting is finished. 
   Image Modified 

...

Anchor

...

DM_WB_Sorting_Quick DM_WB_Sorting_Quick

Quick Column Sorting

To sort columns quick:

1. Click on the header of the column. The column is active now. 
   Image Modified 
2. Hover with your mouse over the right side of the header until the 'Sort' icon appears. 
   Image Modified 
3. Click on

...

1. the 'Sort'

...

1.  icon. Sorting is done for this column. The sorting information can be viewed in the sorting dialog. 
   INFO: The sorting option is 'ascending' per default. To change the sorting option click on the 'Sort' icon. 
   INFO: Clicking the 'Sort' icon a third time removes the sorting criteria. 
   Image Modified 
2. If needed, repeat steps 1 to 3 to sort another column. Already sorted columns are marked with the 'Sort' icon in the heading. 
   INFO: The order in which the sorting is done is analogous to the order in the dialog, e.g. first sorting is by column A and then after column B, if column A has the same values.
   Image Modified 

Applying Formulas to Sorted Data