Tips for excel

Excel 1335 views 13 replies
User Avatar

Audit
115 Points Joined February 2010

Hai friends,

 

here i like to share one of excel tips which i learnt,



If in Excel U have some datas in Row and u want to copy the same data and to paste in column wise it is possible in Excel

 

Here is the Steps,

1. Select the data which u want to paste in Column wise

2. Place the cusor where u want to paste

3. Left click the mouse in that select the PASTE SPECIAL

4. In that put tick mark in TRANSPOSE

5. Click ok

The same steps for doing Viceversa

 

 

2 Reply Share Follow
On 20 July 2011 at 15:46 Report
Replies (13)
User Avatar

ACA
1432 Points Joined May 2009
g00d sharing.... :) thanks....
Reply
On 20 July 2011 at 15:53
User Avatar

One life one Dream
3525 Points Joined May 2010
Originally posted by : Arvind Sharma
g00d sharing.... :)

thanks....

Reply
On 20 July 2011 at 15:56
User Avatar

Accounts manager-MBA
2150 Points Joined July 2008

thanks for sharing

Reply
On 20 July 2011 at 17:48
User Avatar

Be Patient Live Life
17309 Points Joined December 2010
Originally posted by : valji

thanks for sharing
Reply
On 20 July 2011 at 19:38
User Avatar

CA
302 Points Joined February 2011

Thnx for sharing

Reply
On 20 July 2011 at 22:21
Guest
Originally posted by : NIKITA

Thnx for sharing
Reply
On 20 July 2011 at 22:24
User Avatar

C.A.
109 Points Joined October 2009

thanks for sharing

Reply
On 21 July 2011 at 00:22
User Avatar

PSA
21 Points Joined July 2011

thanx frnd.

Reply
On 21 July 2011 at 10:49
User Avatar

Student
54 Points Joined February 2010

Thanks For Sharing............

Reply
On 21 July 2011 at 11:11
User Avatar

CA-FINAL
4094 Points Joined January 2011

THANX FOR SHARING SIR..........

Reply
On 21 July 2011 at 12:04
User Avatar

CA-final
28 Points Joined December 2009

Thanks for sharin.

Reply
On 21 July 2011 at 12:47
User Avatar

Chief Accounts Officer
29 Points Joined November 2009

thanks for sharing.small things adds value.

Reply
On 21 July 2011 at 14:38
User Avatar

Be Patient Live Life
17309 Points Joined December 2010
Originally posted by : valji

thanks for sharing
Reply
On 25 July 2011 at 09:22


CCI Pro

Leave a Reply

Post Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Recent Threads

More recent discussions | Post

Related Threads
Loading