Sorting in Excel with multiple columns - AdvantEdge Training & Consulting

Sorting in Excel with multiple columns

Excel has tools for complex, or multilayered sorts that involve several columns or headers. There are 2 ways to create a complex sort in Excel.

Method 1 – The Sort button

multi level sorting in excelSelect the all of the data in the table you need to sort. Under the Home tab, click on Sort & Filter in the Editing Group. Then choose Custom Sort (this feature can also be accessed with the Sort button under the Data tab in the Sort and Filter group). A dialog box will pop up.
Check or uncheck the My Data has Headers box, depending on your data. Then change Sort by to the column that has the data that should be sorted first. Use the Add Level button to add other criteria to the sort. You can position the order of sorting with the up and down arrows.
multi level sorting in excel
In this example, the data will first be sorted by Favorite Color, then by Favorite Animal, then by Order.

Method 2 – Using Filters to Sort

The other way to create a complex sort, meaning sorting by multiple columns, is to use the filter tool.
multi level sorting in excelSelect your data. Then, under the Data tab, toggle on Filter under the Sort and Filter group. Drop down arrows will appear in each of your columns.
multi level sorting in excelThese drop down arrows offer a few different tools. You can filter the rows by value or color, and you can also sort alphabetically or sequentially either direction.
Use the sorting tools in order to organize your data the way that you need it to be organized, sorting and resorting the data in the appropriate order.

Saving Custom Sorting in Excel

After programming a complex sort in Excel, it is often helpful to save that sort to use again on the same table. You should be able to do this automatically as the sort settings are saved with the document. Simple select the exact same cells and click on the sort button again. If your saved sort isn’t offered, try selecting the entire worksheet with Control + A, and then clicking on the sort button.

For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top