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

4 Answers

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.

2

This is barely programming related, but none the less here is how you do it:

If you're running Excel 2007, mark the area you want to sort, select the "data" tab, hit "sort" and then choose how you want to sort your data. To add more levels of sorting, hit the "Add level"-button.

Select the data

File -> Data -> Sort

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

It's possible. if u try in Excel 2007. Select the columns and data tab and hit Sort tab and in the Sort tab which column you require first, last or whatever prefernece you like and whether it is asc or desc, we can choose from "Add Level" button. It works more than 3 !

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy