Edit a multi-level sorting

To change the sorting settings for the range of filtering:

1.Click /  Sort and filter in one of the upper cells of the range for which sorting was performed.

2.In the Sort and filter window, click Options. The Custom sorting window opens with the current sorting parameters.

3.Make the necessary changes and click Apply in the Custom sorting window.

4.Click Apply in the Sort and filter window.

The appearance of the sort and filter button may differ from the one shown here, as it depends on the sort order and whether a filter has been applied:

–: Sorted in ascending order with no filter applied.

–: Sorted in descending order with no filter applied.

–: Sorted in ascending order with filter applied.

–: Sorted in descending order with filter applied.

To change the sorting settings for the selected range:

1.Select the range again.

2.Open the Custom sorting window.

3.Edit the parameters in the window.

4.Click Apply at the bottom of the window.