Most of the time when you're sorting in Excel, you sort based on the values in one or more columns. If your workbooks are like mine, it's rare that you sort horizontally, based on the values in a row.
It is possible though, and you can sort in ascending, descending, or custom sort order.
Change the Sort Options
To sort by row, click the Options button in the Sort dialog box. Then, in the Sort Options, select Sort Left to Right.
In the screen shot below, the total row has been sorted, so the month with the highest total is at the left.
Excel 2010 Sorting
So much has changed in Excel 2010 and Excel 2007 sorting, that I've finally updated the sorting in Excel page on the Contextures website. You can find the detailed instructions for sorting by row, and other sorting tips.
There is also an Excel sorting sample workbook that you can download, at the bottom of the sorting page.
Watch the Excel 2010 Sorting Video
To see the steps for sorting a row in Excel 2010, you can watch this short Excel video tutorial.
Or watch the video on YouTube: Sort Data in Excel Rows
________________
29 22 16 10 20 2
6 33 4 8 34 21
15 30 9 3 14 19
2 18 19 39 6 12
40 32 1 6 2 11
36 4 3 10 22 29
25 9 33 11 32 35
12 20 25 30 6 21
38 40 6 37 9 36
27 12 10 14 20 40
31 2 7 22 36 24
22 39 36 20 8 32
How can I sort a range of numbers so that each row is in assending order. There are 2000 rows in my spreadsheet and I would like each row in order from lowest to highest. Too time consuming to do it row for row. Any details for doing this quickly would be appreciated.
I have the same problem as Debbie: lots of rows I would like to sort in ascending order by value without writing a macro (yes, I do know how to write the macro).