How to sort multiple columns from left to right in Excel?
You may meet some tables or ranges as following screen shot shows occasionally. It is easy to perform a vertical sort in one column. But how could you sort multiple columns horizontally from left to right across several columns in Excel? Such as to sort the sales amount in January from left to right in the following screenshot. This article will guide you to sort multiple columns from left to right in Excel.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
Step 1: Select the range that you will sort columns horizontally. In this case, select the B1:F8.
Step 2: Click the biggest Sort button in Sort & Filter group under Data tab. See the following screen shot:
You can also click the Home >> Sort & Filter >> Custom.
Step 3: In the Sort dialog box, click the Options button at the header, see the following screen shot.
Step 4: Now Sort Options dialog box pops up, check the Sort left to right option and click OK.
Step 5: And then you will go back to the Sort dialog box, specify the sorting rows and sorting orders based on your needs.
Step 6: Click OK.
Then it sorts the selected columns from left to right based on the sorting row specified in Step 5.
Please note that Microsoft Excel will remember your modification of sorting orientation in Step 4. It means that it will sort horizontally from left to right when you perform a sort next time in Excel.
Recommended Productivity Tools
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 5 months ago"February" is misspelled in the screenshot.
To post as a guest, your comment is unpublished.· 1 years agoI used your steps above with these these columns & rows below:
39 34 46 10 66
14 15 49 65 68
46 37 33 67 55
3 46 15 64 63
38 1 6 7 66
43 61 36 50 11
47 59 14 23 34
62 48 36 52 12
66 54 22 12 8
40 24 45 51 47
60 33 70 5 40
54 15 38 29 1
22 24 20 24 5
8 8 45 64 4
51 15 62 51 26
26 18 10 70 39
The only row that sorted was row 2 -- any idea on how I can get all the rest of them done without doing them one row at a time ???
To post as a guest, your comment is unpublished.· 4 years agovery helpful thank you.