The Multi-level sort guide
Click a cell in the table and open Data → Sort. Choose the first column under Sort by, then Add Level and choose the second under Then by. The first level decides the order; the second only orders rows that tie on the first.
Levels, top to bottom
In the Sort dialog each line is a level. Excel sorts by the top one first and uses the next only inside groups that are equal on it: by Region, then by Sales, gives East's reps together, biggest first, then North's. Microsoft allows up to 64 levels. Tick My data has headers (on a Mac, My list has headers) so the header row stays on top.
Step by step
- Click one cell in the table. Excel picks up the whole block, so rows stay together.
- Data → Sort. Sort by Region, order A to Z.
- Add Level. Then by Sales, order Largest to Smallest.
- OK.
The two-click way
With the quick A→Z and Z→A buttons you can get the same result by sorting twice, in reverse order: first by the second key (Sales, largest first), then by the first key (Region, A to Z). Rows that tie on Region keep the order the first sort gave them. Microsoft doesn't document why this works, so the dialog is the safer habit.
Common mistakes
- Levels in the wrong order. Sales on top splits the regions up across the list.
- Sorting one column alone. Select a whole column and sort it, and only that column moves: names end up next to someone else's sales. See sort without breaking rows.
- The header sorted into the data. Tick My data has headers.
FAQ
- How do I sort by two columns in Excel?
- Data → Sort. Sort by the first column, then click Add Level and choose the second column under Then by. Set the order for each, and press OK.
- Which column should be the first sort level?
- The one that forms the groups, like Region. The second level orders the rows inside each group, like Sales from largest to smallest.
- How many sort levels can Excel use?
- Up to 64 in one sort, according to Microsoft.
- Why does my second sort undo the first?
- A plain sort replaces the order. Use the Sort dialog with two levels, or sort by the second column first and the first column last.



































































