How can I paste a column upside down?

  • Thread starter Thread starter Guest
  • Start date Start date
Hi Sufian,

You can't do that in the paste operation, you need to Sort the column
after it is pasted. If the column is already in an ascending or descending
order, simply highlight the data, go to Data>Sort and check sort ascending
or descending.

If the data is fluctuating you will need to insert a helper column next to
it,
put 1 in the first cell, 2 in the second, then highlight both cells, grab
the
fill handle and drag down to the end of your data.

Highlight both columns and go to Data>Sort select the helper column
from the pulldown and check either ascending or descending.

You can delete the helper column when you finish.

HTH
Martin
 
Fill an adjacent column with consecutive numbers.
Sort the data column and the numbers column descending,
using the numbers column as the key.
Copy the data column and paste it.
Sort the numbers column and the data column ascending.
Clear the numbers column.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Sufian"
wrote in message
When I copy a column, how can I paste a column upside down?
 
If you know the last cell row number in column A just enter this in B1 and
doubleclick on the fill handle of B1.

=INDEX($A$1:$A$120,120-(ROW(A1)-1))

Adjust 120 in both cases to your last row number.


Gord Dibben MS Excel MVP
 
Back
Top