If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copy ranges and pasting in reverse order?
How do I copy a range of horizontal cells and then paste
them in reverse order? |
#2
|
|||
|
|||
Copy ranges and pasting in reverse order?
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 "steve" wrote in message ... How do I copy a range of horizontal cells and then paste them in reverse order? |
#3
|
|||
|
|||
Copy ranges and pasting in reverse order?
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 -- Regards, Peo Sjoblom "steve" wrote in message ... How do I copy a range of horizontal cells and then paste them in reverse order? |
#4
|
|||
|
|||
Copy ranges and pasting in reverse order?
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. "steve" wrote in message ... How do I copy a range of horizontal cells and then paste them in reverse order? |
Thread Tools | |
Display Modes | |
|
|