up vote 8 down vote favorite
share [g+] share [fb]

How do I sort the columns of an Excel spreadsheet? The Sort command from the Data menu only allows me to sort rows by the value of a column. I want to sort the columns alphabetically by the contents of a specific row.

How can I do this?

link|improve this question
86% accept rate
feedback

1 Answer

up vote 12 down vote accepted

Its a custom sort in the Data sorting. See here for more info. enter image description here

link|improve this answer
1  
+1 I learned something new today!! :) – Kaze Aug 1 '11 at 15:08
3  
Me too :) my first answer was that it was not possible, then I decided to check – soandos Aug 1 '11 at 15:08
1  
Great answer, especially with the illustrations -- thanks! – Super Chicken Aug 2 '11 at 14:35
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.