Create a multi-level sorting

You can run the multi-level sorting using the Custom sorting window.

To open the Custom sorting window for the selected range, follow the steps below:

1.Select the cell range for which you want to perform sorting.

2.Open the Custom sorting window in one of the following ways:

•On the Home tab, in the Data group, click the arrow to the right of the  Sort button. In the drop-down list, select Custom sorting.

•On the Data tab, click the arrow to the right of the  Sort button. In the drop-down list, select Custom sorting.

•Right-click any cell in the selected range and select Sort > Custom sorting.

•Press Ctrl+Shift+R (Windows, Linux) or ⌘Cmd+⇧Shift+R (macOS).

To open the Custom sorting window for the sort and filter range, follow these steps:

1.Click the button in one of the top cells of the range.

2.In the Sort and filter window, in the Sort type drop-down list, select Custom sorting.

Next, in the Custom sorting window, configure multi-level sorting as follows:

1.Select the Columns have titles checkbox if you want to use the values of the upper cells as column titles. Titles will not be part of the sorting. This option is only available for the selected range; for sorting and filtering ranges, the upper cells of the range are always used as titles.

2.Configure the sorting for the first level by selecting the required parameters in the row with it:

•In the Column column, select the name of the column you want to sort by from the drop-down list.

•In the Sort column, select a sorting criterion from the drop-down list: by value, by fill color, or by font color.

•In the Order column, select the sort order based on the selected criterion in the Sort column.

•In the Color column, select a fill color or font color to sort by.

3.Add the required number of new levels by clicking  Add sorting level button on the top panel of the window or duplicate the selected row by clicking the  Duplicate sorting level. Duplication may be convenient when the same parameters are used for different levels.

4.Configure the sorting of each new level by selecting the parameters in the corresponding row, similar to the first level (see above).

5.If necessary, you can change the order of the levels or delete unnecessary ones.

6.At the bottom of the window, click Apply.

Once you have created the sort for a sort range and filtered it, its parameters can be changed. To change the sorting parameters made for a selected range, the sorting will have to be performed again.