Excel How to Sort Multiple Columns: Custom Order in One Click

I wasted 45 minutes last week reordering a spreadsheet manually. Then I remembered Excel’s multi-column sort feature and finished the same task in 30 seconds. No macros, no add-ons—just a built-in tool most users overlook.

The trick is layering your sort criteria properly. Add the first column, then the second, and Excel applies them in order. I’ve used this for inventory lists, time logs, and even my vintage ThinkPad collection spreadsheet.

You’ll get perfectly organized data without the headache of manual adjustments. The interface is foolproof once you know where to click, and it works the same in Excel 2016 through the latest version.

Handles custom orders, dates, or text with equal ease. Here’s how to set it up in one click.

What Youll Need

Instructions

Here’s the procedure I follow to sort by multiple criteria without losing data relationships.

Click and drag to highlight all cells containing data, including column headers. I always verify by checking that the last cell in the bottom-right corner shows the active cell reference—this confirms the entire range is selected.

Don’t just select one column. Sorting by a single column breaks existing relationships between data points. The entire dataset must be selected to maintain integrity across rows.

Go to the Data tab in the ribbon, then click Sort. This opens the custom sort dialog where you’ll define your sorting criteria. If Sort is grayed out, double-check that your selection includes headers.

In the dialog, ensure My data has headers is checked. This tells Excel to treat the first row as column names rather than data to be sorted, which prevents your headers from getting mixed into the dataset.

Click Add Level for each column you want to sort by. The topmost level in the list takes priority. For example, to sort by Department first and then by Last Name within each department, add Department as the first level and Last Name as the second.

For each level, select the column from the dropdown and choose Sort On: Values and Order: A to Z (or Z to A for descending). To sort by custom lists like days of the week or months, select Order: Custom List and choose your predefined sequence.

Click OK to apply the sort. Excel rearranges the entire dataset based on your specified criteria. Watch the status bar at the bottom of the window—it will show Sorting… until the operation completes.

Verify by scrolling through the data. Check that rows maintain their relationships (e.g., a person’s first name, last name, and department stay together) and that the primary sort column is ordered correctly. If something looks off, undo immediately with Ctrl+Z and recheck your sort levels.

To reuse this sort configuration, save it as a custom view. Go to View > Custom Views > Add, then name your view. This is especially useful for recurring reports where you need to apply the same multi-column sort repeatedly.

If you frequently sort by the same criteria, consider recording a macro. Go to View > Macros > Record Macro, perform your sort, then stop recording. The next time you need it, just run the macro.

Tips and Common Mistakes

Small oversights can break your multi-column sort—here’s how to avoid them.

Selection Strategy: In Step 1, always verify the active cell reference appears in the bottom-right corner. I’ve seen users accidentally select only visible cells, ignoring hidden columns, which breaks row relationships. Drag beyond visible data to catch everything.

Header Handling: If the Sort option is grayed out in Step 2, your selection likely excludes headers. Excel requires headers to be part of the selection for custom sorts—double-check that the top row is highlighted.

Priority Logic: In Step 3, remember that the topmost sort level takes absolute precedence. If you sort by Department first and Last Name second, Excel groups all matching departments together before alphabetizing names within each group. Get this order wrong, and your data won’t organize as intended.

Verification Habit: After applying the sort in Step 4, scroll to the bottom of your dataset. I catch most errors by checking if the last row’s relationships (like matching first/last names) are intact—this is faster than scanning the entire sheet.

Frequently Asked Questions

Sorting multiple columns in Excel is a powerful way to organize your data efficiently. With just a few clicks, you can customize the order and streamline your workflow. Ready to take it further? Try combining sorting with filtering to unlock even more data management possibilities! 🚀