Changing Sort Orientation in Excel – Sorting across columns instead of rows

Posted on July 22nd, 2008 in hacks , Learn Excel , technology - 8 comments

change-sort-orientation-excel-columns

how-to-sort-across-columns-orientation-change

You can sort data across columns instead of rows by changing sort options. If you ever had to sort across columns now you know a simple way to do this :)

Follow these steps for changing sort orientation:

  • Select the table you want to sort (just the data, not the headers as when you change sort orientation, you cannot set header rows)
  • Go to Data > Sort
  • Click on Options
  • Set “Sort Orientation” to “left to right” instead of “top to bottom” as shown below:
    sort-options-to-change-orientation
  • Click OK

Also see: How to count words in an excel cell, Fill only weekdays when auto-filling dates, Find unique items in a list

Your email address is safe with us. Our policies

Written by Chandoo
Tags: , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

8 Responses to “Changing Sort Orientation in Excel – Sorting across columns instead of rows”

  1. […] this? Also learn how to sort horizontally, fill only weekdays while auto-filling dates Tags: Excel Tips, how to, learn, random, […]

  2. […] if your data flows from left to right instead of top to bottom. Just change the sort orientation from “sort options” in the data > sort […]

  3. […] if your data flows from left to right instead of top to bottom. Just change the sort orientation from “sort options” in the data > sort […]

  4. Chris Scheffler says:

    Thank you so much
    I wasted so much time looking for a formula to sort some values. Then I found this site. Data Tab, then Sort. It’s so easy.
    Thanks again.

  5. Jamal says:

    Thanks……..

  6. […] if your data flows from left to right instead of top to bottom. Just change the sort orientation from “sort options” in the data > sort […]

  7. Mithilsh says:

    Fantastic info……thanks Chandoo

Leave a Reply