If a sort was performed for a sort and filter range, its current parameters can be changed without creating a new sort. To do this, proceed as follows:

1.Click the sorting_ascending_icon button 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:

– sorting_ascending_icon : Sorted in ascending order with no filter applied.

– sorting_descending_icon : Sorted in descending order with no filter applied.

– sorting_ascending_filter_icon : Sorted in ascending order with filter applied.

– sorting_descending_filter_icon : Sorted in descending order with filter applied.

Was this helpful?

Yes