Excel’s sort feature allows you to sort on up to three different columns. If you need to sort on more than three, you can sort the same range multiple times. This takes advantage of the fact that if two values are equal, Excel will keep them in their original order. For this to work properly, you must sort in reverse order. For instance, if you’re sorting on five columns, first sort on columns 3,4,5, then sort on 1,2.
In this example, the data is sorted on Company Name, Contact Name, Country, Region, City, in that order.
The unsorted range:
The first sort:
The second sort:
The final sorted range: