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

change-sort-orientation-excel-columns

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:
  
• 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