Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How to sort more than three columns in Excel
Article ID: 268007 - View products that this article applies to.
This article was previously published under Q268007
Microsoft Excel limits you to a maximum of three columns or fields when you sort a list. If you want to sort a list of more than three fields, you must sort multiple times, with three or fewer fields at a time. Also, you must sort the fields in the reverse order of their importance in the sort.
This step-by-step article contains an example of how to sort a list by more than three fields.
A1: Manager B1: Employee C1: Amount D1: Year A2: Bob B2: Mark C2: 1 D2: 1999 A3: Bob B3: Paul C3: 1 D3: 1991 A4: Bob B4: Paul C4: 1 D4: 1993 A5: Bob B5: Paul C5: 1 D5: 1999 A6: Bob B6: Paul C6: 2 D6: 2000 A7: Sue B7: Jane C7: 1 D7: 1990 A8: Sue B8: Jane C8: 1 D8: 1995 A9: Sue B9: Jane C9: 1 D9: 1999 A10: Sue B10: Jane C10: 2 D10: 1998 A11: Sue B11: Mary C11: 2 D11: 1993
For more information about sorting, click Microsoft Excel Help on the Help menu, type sort a list in the Office Assistant or the Answer Wizard, and then click Search to view the topic.