Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
For my job, I frequently need to reverse the order of columns in Excel.
I'll get a feed of financial data that goes 2006 2005 2004 2003 (etc), and I need to make it go 2003 2004 2005 2006. The good news is that I know how to do this by sorting. The bad news is that I spend 5% of my work week doing it. I know it's just a few keystrokes, but it's a hassle, and they add up over time. I should also note that the data format is sometimes unusual, so I almost always have to create a helper row. However, the data always comes to me in exactly the reverse of the order that I want it. In other words, I do not need to "sort," as much as I need to "reverse." I'd like to be able to simply highlight the rows and use a shortcut. Does there exist a routine to do this for me? If not, does there exist a similar routine that could easily be modified? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
format macro | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
I typed a column in reverse order, how do I flip it (upside down). | Charts and Charting in Excel |