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

On Thu, 4 Oct 2007 13:49:01 -0700, Sufian
wrote:

When I copy a column, how can I paste a column upside down?