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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. 8
paste in Reverse Order 3
copy & pasting automatic formulas 3
Reverse string on multiply cells 3
SPELL IN REVERSE ORDER 2
Reverse Order 2
Excell rank= I need to reverse the order 2
Reverse Order of Data Set 3

Back
Top