

Today, we got a quick tip for you: Sort data left to right. Most Excel users don’t know that it is possible to sort horizontally. Admittedly, the option is a little bit hidden in Excel. But once you know it, it’s not a big deal.
As the option for sorting data left to right is a little bit hidden in Excel, most users either drag and drop rows manually or transpose them first. But that’s not necessary! There is an easy method letting Excel sort your data horizontally for you.
Actually sorting data left to right in Excel is quite simple. You just have to change the Sort Options from “Sort top to bottom” to “Sort left to right”.
Example: Sort this table by car type.
The example: You got the simple table as shown in the image on the right hand side. Row 1 contains cars (here just shown by their type) and row 2 has the corresponding price. You want to sort the table by the car type.
Sort data left to right in Excel.
Follow these steps:
Please note: Excel saves your last selection. Next time you want to sort a table top to bottom you have to switch the sort direction back to “Sort top to bottom”.
The complete process one more time as an animation. Keep in mind, that you should not include the title column (column A) in your selection.
Sort data horizontally in Excel
Do you want to know more about sorting options in Excel? We’ve already published articles for basic sorting knowledge and how to use filters or advanced filters. Also Pivot Tables offer a lot of sorting options.
'Professor Excel Tools': Add more than 60 amazing features to Excel!
Professor's Error Helper for Excel: Solve any error in Excel.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
Subscribe to our popular Excel newsletter! You get all this:
Your welcome gift: Our big 45 pages keyboard shortcuts package.
Subscribe now! In case the sign-up form above doesn't work, please use this page. Sorry for the inconvenience.
Please use this download link to download the Currency Converter Excel add-in!
Please use this download link to download the comment extraction example: http://bit.ly/Extract_Comment_Example