20

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?

34

It's a custom sort in the Data sorting.

From the Data tab click on the Sort button to open the Sort dialog box, click on Options to open the Sort Options dialog box and select Sort left to right. See here for more info.

sort by row steps

  • 5
    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
  • wish there were a way to do this in early versions – datatoo Jul 20 '12 at 20:41

Your Answer

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

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