Excel 2007: How to Sort Rows
Contributed by Rob Rogers 
Tagged: Microsoft Excel By default, Excel allows you to sort your data by columns. If you run into a situation that requires that you sort the rows, you could do it by hand or let Excel do it for you.
1. Highlight the data to be sorted.
2. Go to the Ribbon and select the Data tab.
3. In the Sort & Filter section, select Sort.
4. In the Sort window, click the Options button.
5. In the Orientation section, select the Sort left to right radio button.
6. Click the OK button.
7. Now use the dropdowns in the Sort window to select the desired row and how you want it sorted.
8. Click the OK button.
You may also like -
Excel 2007: Have Your Data Read Back To You
Excel 2007: Clear All Formatting From a Range of Cells
Excel 2007: Eliminate Blank Rows in a Spreadsheet
Excel 2007: Set the Default Column Width for a Worksheet
Excel 2007: Use Data Bars for Cell Value Analysis
Excel 2007: Change the Default File Location
Excel 2007: Automatically Remove Duplicates
Excel: Prevent Conversion of URLs into Hyperlinks
Art said on December 3, 2008
Great tip.
John Roberts said on December 4, 2008
Did’t know that you can sort sideways. Something new in Excel 2007.
Thank you
Nathck said on March 10, 2011
What is going on that I can’t select the sort option?
MEG1963 said on March 22, 2011
Finally, a nice feature for the new version. Not Digging the ribbon too much at all.
Kannan said on April 8, 2011
Thanks
excel training in london said on August 4, 2011
Great tutorial given in your blog.I am impressed.Given post in your blog is simple yet so descriptive.
lee said on December 1, 2011
ONCE AGAIN, A TASK THAT WAS ONCE SO SIMPLE AND EASY, has been made more difficult deemed so by “those” that seem to think they know what is best for ALL OF US???!!!