Copy ranges and pasting in reverse order?

  • Thread starter Thread starter steve
  • Start date Start date
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
 
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
 
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.
 
Back
Top