Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

up vote 18 down vote accepted

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

share|improve this answer
+1 I learned something new today!! :) –  Ellesa Aug 1 '11 at 15:08
Me too :) my first answer was that it was not possible, then I decided to check –  soandos Aug 1 '11 at 15:08
Great answer, especially with the illustrations -- thanks! –  Super Chicken Aug 2 '11 at 14:35
wish there were a way to do this in early versions –  datatoo Jul 20 '12 at 20:41

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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