One way ... using a formula:

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

And copy down.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Todd" wrote in message
...
I have several columns of data and the data is listed upside down. SO, I
want to change it so the last line is first and the first line is last and
all the lines/rows in between are inverted as well. I know there's a simple
way to do this in excel but I don't know how.