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

Posted on July 22nd, 2008 in Learn Excel , hacks , technology - 5 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:
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

| More

Posts & Navigation

Tags: data, learn, Learn Excel, microsoft, sorting, technology, tips, tricks

Trackbacks & Pingbacks

Pingback by Shuffle a list of numbers / items in excel spreadsheet | Pointy Haired Dilbert - Chandoo.org on July 28, 2008 @ 1:31 pm

Pingback by Excel can be Exciting : 15 Fun things to do with Microsoft Excel | Pointy Haired Dilbert - Chandoo.org on August 1, 2008 @ 10:38 am

Pingback by Sorting a list of items in random order in excel - using formulas | Pointy Haired Dilbert - Chandoo.org on September 23, 2008 @ 3:36 pm

Pingback by Excel can be Exciting - 15 fun things you can do with your spreadsheet in less than 5 seconds « ZamaZ Cool Blog on November 25, 2008 @ 11:51 am

Comments

Chris Scheffler March 20, 2009

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.

RSS feed for comments on this post. TrackBack URI