Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I want to reverse the order of columns in a worksheet. Specifically, someone
has sent me a file of utility usage data in which the most recent date is in column B and the oldest date is in column M. I want to reverse that, putting the most recent date in M and the earliest in B. Is there a way to do this without manually cutting and pasting? |
#2
![]() |
|||
|
|||
![]()
Yes. DataSort, click Options, and then Left to Right, OK, Descending
-- Kind Regards, Niek Otten Microsoft MVP - Excel "Bill Meacham" wrote in message ... I want to reverse the order of columns in a worksheet. Specifically, someone has sent me a file of utility usage data in which the most recent date is in column B and the oldest date is in column M. I want to reverse that, putting the most recent date in M and the earliest in B. Is there a way to do this without manually cutting and pasting? |
#3
![]() |
|||
|
|||
![]()
Great! Thanks!
"Niek Otten" wrote: Yes. DataSort, click Options, and then Left to Right, OK, Descending -- Kind Regards, Niek Otten Microsoft MVP - Excel "Bill Meacham" wrote in message ... I want to reverse the order of columns in a worksheet. Specifically, someone has sent me a file of utility usage data in which the most recent date is in column B and the oldest date is in column M. I want to reverse that, putting the most recent date in M and the earliest in B. Is there a way to do this without manually cutting and pasting? |
#4
![]() |
|||
|
|||
![]()
Here's a small example:
*** Try this on a copy of your file, NOT The Original !! *** WIth your dates (like you say) in a limited range, say B5:M50. Drop down to the bottom of the worksheet and clear of the used area where there's nothing below, say Row 105 and in cell B105 enter =OFFSET($B5,0,13-COLUMN(),) then copy and paste to cells C105:M105 then copy C105:M105 and paste to C106:M150 The dates now in C105:M150 will be what you want, except their not where you want them; Highlight C105:M150, Copy (it) then point to cell B5 and do a Paste-Special Values. It may be necessary to Format the Range B5:M50 to the desired date format you want. Hope this helps,,, Jim May "Niek Otten" wrote in message ... Yes. DataSort, click Options, and then Left to Right, OK, Descending -- Kind Regards, Niek Otten Microsoft MVP - Excel "Bill Meacham" wrote in message ... I want to reverse the order of columns in a worksheet. Specifically, someone has sent me a file of utility usage data in which the most recent date is in column B and the oldest date is in column M. I want to reverse that, putting the most recent date in M and the earliest in B. Is there a way to do this without manually cutting and pasting? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I reverse the order of a column of numbers . . . | Excel Discussion (Misc queries) | |||
How can I reverse the order of a column of numbers . . . | Excel Discussion (Misc queries) | |||
sort in reverse order | Excel Discussion (Misc queries) | |||
I typed a column in reverse order, how do I flip it (upside down). | Charts and Charting in Excel | |||
how to paste the values in reverse order in workbook | Excel Discussion (Misc queries) |