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

Sponsored Links



How to reverse column in excel

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 09-06-2009
Member
 
Join Date: Dec 2008
Posts: 19
How to reverse column in excel
  

I have a many column in excel i want to reverse the list from bottom to top and the list is then upside down. Can some one help me ?

Thanks

Reply With Quote
  #2  
Old 09-06-2009
Member
 
Join Date: Dec 2008
Posts: 40
Re: How to reverse column in excel

Go in adjacent column then insert one if you have to, Use Edit, Fill, Series to insert the numbers in the adjacent column. Then do a data sort on both columns at the same time using the column you filled as the sort by column and sorting in descending order.
Reply With Quote
  #3  
Old 09-06-2009
Member
 
Join Date: Dec 2008
Posts: 41
Re: How to reverse column in excel

You can highlight both columns and sort these running number in DESCENDING order.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to reverse column in excel"
Thread Thread Starter Forum Replies Last Post
It is possible to get reverse text Microsoft Excel Indudep MS Office Support 4 25-01-2012 06:17 PM
Need help to reverse the name order in Microsoft Excel Kesar MS Office Support 3 24-01-2012 02:16 PM
How to Reverse Row Order in Microsoft Excel Raju Chacha MS Office Support 1 14-01-2012 06:25 PM
Sort a row or column in MS Excel Itronix Tips & Tweaks 1 15-06-2011 10:52 AM
How can I reverse the order of text on a Excel cell Sunny55 Windows Software 3 06-06-2009 10:50 PM


All times are GMT +5.5. The time now is 10:02 PM.