Copy ranges and pasting in reverse order?

[steve]

How do I copy a range of horizontal cells and then paste
them in reverse order?

 

[Bernie Deitrick]

Copy them, paste them, then insert a row above or below and fill with
the formula =Column(). Then select the pasted row and the formula
row, and sort horizontally based on the row with the formula in
descending order.

HTH,
Bernie
MS Excel MVP

 

[Peo Sjoblom]

You can't. You have to use a help row, put 1,2,3 and so on, then select both
ranges and sort
descending on the help row. Then you can delete the help row. Now you can
copy and paste
to your liking

 

[Dave R.]

One way; copy your cells as they are to a seperate location.
in a row above/below your cells, enter 1,2,3,4 (or use 1, A1+1, B1+1, etc
etc)
Then select the range of cells and the 1,2,3,4 numbers, and go to sort.
under options, select 'sort left to right', then OK. then sort on the row
that contains the numbers, descending or ascending to change the order.