|
-
May 21st, 2006, 03:56 AM
#1
Thread Starter
Hyperactive Member
Need help in excel
Hi I want to ask how I can change the Columns left to right, right to left
and also row Up to down, down to up. for example I have text in Excel
sheet like this:
EXAMPLE – 1 Column Left - Right
[ ][ A ][ B ][ C ][ D ][ E ][ F ]
[ 1 ] Aa Ba Ca Da Ea Fa
[ 2 ] Ab Bb Cb Db Eb Fb
[ 3 ] Ac Bc Cc Dc Ec Fc
And I want to change lift to right like this.
[ ][ A ][ B ][ C ][ D ][ E ][ F ]
[ 1 ] Fa Ea Da Ca Ba Aa
[ 2 ] Fb Eb Db Cb Bb Ab
[ 3 ] Fc Ec Dc Cc Bc Ac
EXAMPLE – 2 Row Up - Down
[ ][ A ][ B ][ C ][ D ][ E ][ F ]
[ 1 ] Aa Ab Ac
[ 2 ] Ba Bb Bc
[ 3 ] Ca Cb Cc
[ 4 ] Da Db Dc
[ 5 ] Ea Eb Ec
[ 6 ] Fa Fb Fc
And I want to change up to down like this.
[ ][ A ][ B ][ C ][ D ][ E ][ F ]
[ 1 ] Fa Fb Fc
[ 2 ] Ea Eb Ec
[ 3 ] Da Db Dc
[ 4 ] Ca Cb Cc
[ 5 ] Ba Bb Bc
[ 6 ] Aa Ab Ac
I hope my question is understandable, please tell me that it is possible
or no?
Thank you for your attention.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|