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


Sign-up for our FREE Excel tips newsletter:

Free Excel tips book - joining bonus - Chandoo.org newsletter

Here is a smart way to become awesome in Excel. Just signup for my FREE Excel tips newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:

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