If the columns are all contiguous then, insert another colum enter 1 in the
first cell, 2 in the second, highlight both cells and hover the cursor over
the "fill Handle" in the bottom right-hand corner whereupon the cursor will
turn into a cross-hair and left click which will fill the series in the
length of the adjacent column.

Now highlight all the columns that you want to invert and sort in decending
order using the inserted column as the sort column.

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"bamboo" wrote in
message ...

i have to like invert several colums... i dont know how to do that
without retyping the whole thing, is there another way?


--
bamboo
------------------------------------------------------------------------
bamboo's Profile:
http://www.excelforum.com/member.php...o&userid=26721
View this thread: http://www.excelforum.com/showthread...hreadid=399753