Sort Data Row-Wise

We have been using Sort function for so long in our work but still one of the very unexplored feature of this function is that we can sort data row wise also. This could be useful in some cases, where our data is in horizontal manner. So let’s see how we can do it…..

I have created a dummy data for this:

First we need to select the data

And then go to Data Tab

Then a Sort dialog box will appear. In this box first click on Options.. and choose Sort left to right instead of top to bottom and then press OK.

Now from the dropdown in the box choose your desired row and choose order and then press OK.

And we are done… :-)

If you like my post, then you can just put in your email ID at the top right corner of the page and you will get a FREE weekly newsletter with amazing Excel tips and notification of my latest post on this blog.