Changing Sort Orientation in Excel – Sorting across columns instead of rows
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
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Google Maps adds directions by Public Transport – Wow||Extract URLs from an excel spreadsheet cell using UDFs »|