fbpx

How to sort left to right in Excel (quick tip)

Share

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Imagine you are in a life sustaining planet named Pearth, in another galaxy. One day you got to work, fired up Excel (hey, what else would you use? Excel is the best data software in any galaxy 🙂 ) and started working.

You came across a dataset that need sorting, but left to right – horizontally.

Sort left to right in Excel - horizontal sorting of data in spreadsheets

Now what? Do you turn your monitor sideways?

Nope, just use left to right sort option from Custom sort. That is right my dear alien friend. You can sort data in horizontal direction too.

See this quick demo.

Sort left to right in Excel – instructions

Left to right sorting is easier than it looks. Just follow these instructions.

  1. Select your data. But exclude headers (ie first column)
  2. Now go to Home > Sort & Filter > Custom sort
  3. Click on “options”
  4. Now select “Sort left to right”, click OK.
  5. Now you can set sorting by row, rather than column.
  6. Specify row number you want to sort on and sort order.
  7. Click ok and your data is sorted.

Want to fix your data instead? Just transpose it

If you want to just change the shape of your data, you can quickly transpose it using one of the below techniques.

  1. Copy and Paste transpose: You can quickly transpose data using copy paste. Copy your data (Ctrl+C), Paste Special (CLTR+ALT+V), Transpose. See this 15 second tutorial if you have doubts.
  2. Transpose data with formulas: If you don’t want to copy, then you can use formulas to transpose. See this tip to transpose data with formulas.
  3. Transpose with Power Query: If you are getting data from a source (text file, webpage, SQL query etc.) then you can use Power Query to add tranpose as part of load process. Here is a quick introduction to Power Query.

Now that you are on an interplanetary journey, why not pick up few more quick tips for data analysis.

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Chandoo is an awesome teacher
5/5

– Jason

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

2 Responses to “How to sort left to right in Excel (quick tip)”

  1. Marcin says:

    That`s a great tip!

    So many things i discover about Excel every day. And there is still tons to find out 🙂

    My favourite Excel knowledge base.

    Keep up the good work!

  2. Nimesh says:

    That's quite interesting.
    I can see that in 2007 as well, how old is this feature?

    Excel is Pandora's box.

Leave a Reply