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.
Go to the ribbon to the Data tab. Click Sort button.
Sort dialog window appears. Click Options button.
Click 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.
Here you can see how Excel sorted the data. Total row is sorted descending.
This is how to sort by row within Excel.