In this Excel tutorial you will teach yourself how to sort by row. This trick maybe useful for large spreadsheets with many columns.

First prepare you data table. Here is an example.

data table to sort by row

Go to the ribbon to the Data tab. Click Sort button.

ribbon sort button

Sort dialog window appears. Click Options button.

Sort dialog window

Click Sort left to right.

Sort Options sort left to right

Now decide what do you want to sort. I sorted Row7 (which is Total in my table) by Largest to Smallest order.

Way how to sort

Here you can see how Excel sorted the data. Total row is sorted descending.

Data sorted by row

This is how to sort by row within Excel.