Excel 2007: How to Sort Rows

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.


About Rob Rogers

Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
View more articles by Rob Rogers

The Conversation

Follow the reactions below and share your own thoughts.

9 Responses to “Excel 2007: How to Sort Rows”

  1. December 03, 2008 at 12:10 pm, Art said:

    Great tip.


  2. December 04, 2008 at 4:43 pm, John Roberts said:

    Did’t know that you can sort sideways. Something new in Excel 2007.
    Thank you


  3. March 10, 2011 at 9:23 pm, Nathck said:

    What is going on that I can’t select the sort option?


  4. March 22, 2011 at 1:08 pm, MEG1963 said:

    Finally, a nice feature for the new version. Not Digging the ribbon too much at all.


  5. April 08, 2011 at 6:51 am, Kannan said:



  6. August 04, 2011 at 2:45 am, excel training in london said:

    Great tutorial given in your blog.I am impressed.Given post in your blog is simple yet so descriptive.


  7. December 01, 2011 at 1:10 pm, lee said:

    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???!!!


  8. August 24, 2012 at 8:48 pm, victor said:

    the ribbon is just for one row, I need to sort 2000 rows how to do that. I try the recipe above and nothing.


  9. November 11, 2012 at 6:51 pm, Alan Gibbons said:

    I am the scorekeeper at an International Cheese Competition.
    When I sort data in one category, I sort FIRST on overall score, and SECONDLY on Flavor, only if there is a tie.
    The following data does not sort correctly. Values are all fixed at two decimals. Note that entry 6 should have been sorted ahead of entry 5.

    Entry Number Average Overall Score Average Flavour Score
    1 98.30 43.30
    2 98.25 43.25
    3 98.15 43.15
    4 98.00 43.20
    5 97.95 43.10
    6 97.95 43.15
    7 97.90 43.20
    8 97.90 43.00


Leave a Reply