Go Back   TechArena Community > Software > Tips & Tweaks
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Sort a row or column in MS Excel

Tips & Tweaks


Reply
 
Thread Tools Search this Thread
  #1  
Old 04-04-2009
Member
 
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.

Reply With Quote
  #2  
Old 15-06-2011
Member
 
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.
Reply With Quote
Reply

  TechArena Community > Software > Tips & Tweaks
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Sort a row or column in MS Excel"
Thread Thread Starter Forum Replies Last Post
Is it possible to modify Excel Column Names gUILl MS Office Support 2 27-01-2012 08:08 PM
How to sort the name in Excel Sanju Baba Windows Software 1 06-01-2012 10:53 PM
How to sort column in alphabetical order? JskPsk Software Development 4 21-07-2009 08:48 PM
excel blue line of a column Lauren Bacall Windows Software 3 09-06-2009 07:31 PM
How to reverse column in excel Vishant Windows Software 2 09-06-2009 01:53 PM


All times are GMT +5.5. The time now is 03:43 PM.