want to flip (vertically and/or horizontally) a block of num

Do you want to "flip" align vertically from the horizontal position?....right click on the range that you want to modify, Alignment feature, then choose the angle you desire .

A little more info if this is not what you are looking for....


hope this helps...

pll
This message was edited by plettieri on 2002-10-11 15:36

thank you,

For clarification, I want to flip the position of the cells: i.e., if I have values at A1 through D1, after flipping, I want the value of A1 at D1 and vice versa...

Wontanamo,

Suppose you have a block of data in A2:J15.

In cell L1, enter -2
In cell M1, enter =L1-2 and copy over to U1.
In M2, enter =OFFSET(L2,0,L$1,1,1) and copy through the range L2:U15.

L2:U15 should contain the "mirror" of the data in A2:J15. You can then copy and paste values over your old data.

Could also be used to flip top to bottom. Hope this helps

Alriemer

thank you. That worked out great!