Home » Questions » Computers [ Ask a new question ]

Excel, sort multiple columns

Excel, sort multiple columns

How can I sort multiple columns in Excel? So first sort culumn B and then A, D

Asked by: Guest | Views: 185
Total answers/comments: 2
Guest [Entry]

"You can sort on as many columns as you like with any version of Excel, by sorting 1 column at a time, in the reverse order.
E.g: if you need a sort on col. B, F, C, A in that order of precedence, just sort on A, then on C, then on F, then on B."
Guest [Entry]

"Select the data

File -> Data -> Sort

I think you can only sort by upto 3 columns...."