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

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

Hi!

Suppose you want to invert A1:C10

In D1 enter this formula:

=ROW()

Double click the fill handle to copy the formula through D10

Select the range, A1:D10 then sort on column D descending.

After your done delete he formulas in column D.

Biff

"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