Sorting more than 3 colunms the same time

mollywage

New Member
Joined
Oct 24, 2007
Messages
33
I have a worksheet that has 6 columns that need to be sorted alphabetically the same time. As far as I know Excel’s Sort function only allows 3 columns at the time. How do I sort 6 columns the same time? Need help urgently. Thanks.
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Hello,

You might consider to sort in two steps or use code.
Please show a little example.

kind regards?
Erik
 
Upvote 0
far as I know Excel’s Sort function only allows 3 columns at the time

Not EXACTLY true...

You can sort as many columns as you like at the same time...
But only 3 Can be used as Sort Criteria...meaning
Sort By column A Ascending, THEN by Column B Descending, THEN by Column C Ascending...
 
Upvote 0
That’s what I mean by sorting 6 columns by using them as the sort criteria for all 6 columns.
I have tried to sort them in steps, but the second sort will change the first sort’s order.
Any suggestion of how to write the code? Thanks.
 
Upvote 0
For example:

Agric Agric Agric Agric Agric Agric
Agric Agric Agric Agric Agric Produ
Audit Audit Audit AC-No AC-No Annua
Audit Audit Audit AC-No AC-No ERP
Audit Audit Audit Audit Audit Audit
Audit Audit Audit AC-No Debt 2007
Audit Audit Audit AC-No Debt Retir
Audit Audit Audit AC-No Debt S/T B
Board Board Board Board Board Distr
Board Board Board Board Board Distr
Board Board Board Board Board Distr
Board Board Board Board Board Distr
Board Board Board Board Board Distr
Board Board Board Board Board Distr
 
Upvote 0
  1. Select all of Columns A:F
  2. Go to Data>Sort> sort by D then by E then by F
  3. Click Sort
  4. Now again with Columns A:F selected
  5. Go to Data>Sort> sort by A then by B then by C
  6. Click Sort
 
Upvote 0

Forum statistics

Threads
1,213,513
Messages
6,114,064
Members
448,545
Latest member
kj9

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top