22

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?

Improve this question

1 Answer 1

Reset to default
36

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

Improve this answer
4
  • 5
    Me too :) my first answer was that it was not possible, then I decided to check
    – soandos
    Commented Aug 1, 2011 at 15:08
  • 1
    Great answer, especially with the illustrations -- thanks!
    – Super Chicken
    Commented Aug 2, 2011 at 14:35
  • wish there were a way to do this in early versions
    – datatoo
    Commented Jul 20, 2012 at 20:41
  • Normally excel advice can be applied to Google Sheets, but no custom sort in this case there :-(
    – boardtc
    Commented May 10, 2020 at 12:49

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .