How do I sort by multiple columns in Excel?

Use Data > Sort, then add levels for each column you want to sort by.

Why did sorting mess up my Excel data?

This usually happens when only one column was sorted instead of the full related dataset.

Use it on one real task this week, then add a sticky note on your monitor with the shortcut until it becomes automatic.

Most shortcuts differ slightly on Mac (Cmd instead of Ctrl). Check the function or feature page for platform notes when something does not work.

Tips & Tricks - 2026-05-12

Learn how to sort data in Excel by one column, multiple columns, dates, colors, custom lists, and dynamic SORT formulas.

Sorting changes the order of rows based on one or more columns. It is one of the fastest ways to organize spreadsheet data. Before sorting, make sure your data has: One header row No fully blank rows inside the range Related fields in the same row Consistent date and number formats

Click any cell in the column, then use: Data -> Sort A to Z For numbers, Excel sorts smallest to largest. For dates, Excel sorts oldest to newest.

Use the full Sort dialog: Data -> Sort Example: Sort by Region A to Z. Then sort by Sales largest to smallest. This keeps groups together while ranking values inside each group.

If cells use fill colors or font colors, Excel can sort by color. Data -> Sort -> Sort On: Cell Color This is useful after conditional formatting highlights urgent, late, or high-priority records.

In Microsoft 365, SORT creates a dynamic sorted result: \\\ =SORT(A2:D100,2,-1) \\\ This sorts the range by the second column in descending order.

Sorting one column without the rest of the table Having blank rows inside the dataset Dates stored as text Forgetting to expand the selection Sorting a report without keeping a backup

Try the shortcut or setting on a copy of your file first. Pin the technique to your Quick Access Toolbar if you will use it daily. Pair productivity tips with Excel Tables and named ranges for fewer broken references. Explore: Tips archive · Keyboard shortcuts guide

How do I sort by multiple columns in Excel? Use Data > Sort, then add levels for each column you want to sort by.
Why did sorting mess up my Excel data? This usually happens when only one column was sorted instead of the full related dataset.
How do I remember this Excel tip? Use it on one real task this week, then add a sticky note on your monitor with the shortcut until it becomes automatic.
Will this tip work on Mac Excel? Most shortcuts differ slightly on Mac (Cmd instead of Ctrl). Check the function or feature page for platform notes when something does not work.