Results 1 to 2 of 2

Thread: Sort a row or column in MS Excel

  1. #1
    Join Date
    Apr 2008
    Posts
    439

    Sort a row or column in MS Excel

    Microsoft Excel 2007 allows you to sort your data in columns by default. If you want to sort rows in excel 2007, follow the steps given below:
    • Highlight the data to be sorted.
    • Go to the Ribbon and select the Data tab.
    • Select Sort in Sort & Filter section.
    • In the Sort window, click the Options button.
    • In the Orientation section, select the Sort left to right radio button.
    • Click the OK.
    • Now use the dropdowns in the Sort window.
    • Select the desired row and how you want it sorted.
    • Ten click OK.

  2. #2
    Join Date
    May 2009
    Posts
    210

    Re: Sort a row or column in MS Excel

    You can also follow these steps:

    • Start Microsoft Excel and open the file you want to change.
    • Drag over the two or more columns or rows that you want to sort.
    • Open the Data menu and select Sort. The Sort dialog box appears.
    • Select the Continue with the Current Selection option to sort a single column or row.
    • Select the Expand the Selection option to sort a series of columns or rows.
    • Choose Ascending or Descending to determine the sort order.
    • Click the Options button in the Sort dialog box.
    • Select "Sort top to bottom" in the Sort Options dialog box to sort a column.
    • Select "Sort left to right" in the Sort Options dialog box to sort a row.
    • Click OK in the Sort Options dialog box.
    • Click OK in the Sort dialog box.

Similar Threads

  1. Is it possible to modify Excel Column Names
    By gUILl in forum MS Office Support
    Replies: 2
    Last Post: 27-01-2012, 08:08 PM
  2. How to sort the name in Excel
    By Sanju Baba in forum Windows Software
    Replies: 1
    Last Post: 06-01-2012, 10:53 PM
  3. How to sort column in alphabetical order?
    By JskPsk in forum Software Development
    Replies: 4
    Last Post: 21-07-2009, 08:48 PM
  4. excel blue line of a column
    By Lauren Bacall in forum Windows Software
    Replies: 3
    Last Post: 09-06-2009, 07:31 PM
  5. How to reverse column in excel
    By Vishant in forum Windows Software
    Replies: 2
    Last Post: 09-06-2009, 01:53 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,533,498.81223 seconds with 17 queries