Cut a range and paste in opposite order?

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I am trying to cut a range of horizontal cells and then
paste them back in the opposite order of positions. Left
to right to right to left. Is it possible?
 
Steve said:
I am trying to cut a range of horizontal cells and then
paste them back in the opposite order of positions. Left
to right to right to left. Is it possible?
Click to expand...

As far as I know there is no built-in way to do this.
It's quite simple to achieve with formulas, though. For example, if your
data were in A1:A10, you could put this formula in B1:
=OFFSET($A$1,0,10-COLUMN())
and copy it across the range B2:B10.
Then you could copy B1:B10 and use
Paste Special > Values
to overwrite A1:A10, subsequently deleting the formulas in B1:B10.
 
Perhaps a bit faster would be to produce a range of
numbers (1 to n), starting from the left, below the range
of cells you are speaking of. Then select both ranges and
and go to Data > Sort > Options. Select "sort left to
right", OK, and then select the bottom row and sort
descending. Delete the row you created.

Before:

A B C D E
1 j a s o n
2 1 2 3 4 5 <--create this

After:

A B C D E
1 n o s a j
2 5 4 3 2 1

HTH
Jason
Atlanta, GA


HTH
Jason
Atlanta, GA
 
How about numbering the cells in the row below your
horizontal cells. Highlight both rows and sort the
numbered row in decending order.
 
You can copy a range, then do a Paste Special and check
Transpose. You cannot cut the range then do the paste
special, however.
 
Back
Top