How to Sort Data in Excel by One or More Columns

To sort data in Excel, click one cell in the column you want to order by, then choose Data > Sort A to Z or Sort Z to A. To sort by more than one column, such as Region and then Sales, use the Sort dialog and add a level for each column. This guide covers both, plus the mistakes that scramble rows and the SORT function for a live, sorted copy.

How to sort data in Excel by one column#

A one-column sort takes one click. Excel works out where your list starts and ends and moves whole rows together.

Here is a small sales list:

To put the biggest sales first:

1. Click any cell in the Sales column, such as C3. Don't select the whole column.
2. On the Data tab, click Sort Z to A (the button with Z above A). For numbers, Excel's menus call this Sort Largest to Smallest.

Ana's row (61,400) moves to the top, and her name and region move with her. The header row stays put because Excel detects it.

You'll find the same buttons under Home > Sort & Filter. On Windows, you can also use the ribbon keys: press Alt, then A, S, A for A to Z, or Alt, A, S, D for Z to A.

What the sort orders mean#

Blank cells always go to the bottom, whichever direction you choose.

How to sort by multiple columns#

Use the Sort dialog when one column isn't enough. A common request is "group by region, and within each region put the biggest sales first".

1. Click any cell in the list.
2. Go to Data > Sort. (Windows ribbon keys: Alt, A, S, S.)
3. Check that My data has headers is ticked.
4. In Sort by, choose Region. Leave Sort On as Cell Values and Order as A to Z.
5. Click Add Level. In Then by, choose Sales and set Order to Largest to Smallest.
6. Click OK.

The East rows come first, then North, South and West. Inside North, Kenji (52,800) sits above Priya (48,200). The second level only matters for rows that tie on the first level.

You can add more levels the same way, use Delete Level to remove one, and use the arrow buttons to change which level runs first.

Sort by a custom order or by color#

Alphabetical isn't always the order you want. Months, weekdays and labels like Low, Medium, High need a custom order.

• Months and weekdays: in the Sort dialog, open Order, choose Custom List…, and pick the built-in January, February, March list (or the short Jan, Feb, Mar version).
• Your own order: in the same Custom List box, type your entries, such as High, Medium, Low, click Add, then OK.
• By color: set Sort On to Cell Color or Font Color, then pick the color to put on top. This works well after you highlight duplicates with conditional formatting.

To sort columns instead of rows, click Options… in the Sort dialog and choose Sort left to right.

Why does Excel sort my data wrong?#

Most sorting problems come from the data, not the button. Check these before you sort:

1. You selected one column only. Excel shows a Sort Warning. Choose Expand the selection. If you choose Continue with the current selection, only that column moves and every row is scrambled.
2. Blank rows or columns in the middle. Excel treats a fully blank row or column as the edge of the list, so part of your data isn't sorted. Delete the gaps, or select the whole list before sorting.
3. Numbers stored as text. Text numbers sort like words, so 100 comes before 25. Look for green triangles and convert them first.
4. Dates stored as text. Text dates sort by their first characters, not by date. They often sit on the left of the cell, while real dates sit on the right.
5. Merged cells. Excel refuses to sort a range where merged cells are different sizes. Unmerge them first.
6. The header got sorted into the data. Tick My data has headers.

If something goes wrong, press Ctrl+Z (⌘Z on a Mac) at once. A good habit for important lists: add an ID column numbered 1, 2, 3 before you sort, so you can always sort by ID to get the original order back.

Sort with a formula: the SORT function#

The SORT function returns a sorted copy and leaves the original list as it is. It needs Excel 2021, Excel 2024 or Microsoft 365.

=SORT(A2:C8,3,-1)

• A2:C8 is the data to sort (no headers).
• 3 sorts by the third column of that range, Sales.
• -1 means descending, largest first. Use 1 for ascending.

Type it in one cell and the sorted list spills into the cells below and to the right. When a sale changes, the sorted copy updates by itself, which the Sort button can't do. To sort by two columns with a formula, use SORTBY, covered in our guide to SORT and SORTBY.

You can also sort a filtered result in one step. Put a FILTER function inside SORT:

=SORT(FILTER(A2:C8,B2:B8="North"),3,-1)

This lists only the North reps, best seller first.

Sorting vs filtering#

Sorting changes the order of rows; filtering hides rows you don't need. They work well together: filter to one region, then sort by sales. Our guide to filtering data in Excel covers the filter buttons and the Ctrl+Shift+L shortcut that turns them on (⌘⇧F on a Mac).

If your list is an Excel table, the sort buttons are already on every header. Click the arrow next to a header and choose Sort A to Z or Sort Largest to Smallest.

Sorting in office tasks and job tests#

Sorting is one of the first things people check in a practical test. A typical task asks you to rank sales reps, list the oldest open tickets first, or group expenses by category. It's also everyday work in admin roles, as covered in Excel skills for admin and office jobs. Pair it with a drop-down list to keep categories consistent, and your sorts and filters will group everything correctly.

Practise it#

Try the exercise on this page to sort a sales list with a formula. Then practise the SORT function in a live spreadsheet, and practise filtering a table to combine sorting and filtering on real data.