Tips for excel

Excel 1419 views 13 replies

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

 

 

Replies (13)
g00d sharing.... :) thanks....
Originally posted by : Arvind Sharma
g00d sharing.... :)

thanks....

thanks for sharing

Originally posted by : valji

thanks for sharing

Thnx for sharing

Originally posted by : NIKITA

Thnx for sharing

thanks for sharing

thanx frnd.

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

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

Thanks for sharin.

thanks for sharing.small things adds value.

Originally posted by : valji

thanks for sharing


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 14 March 2026
Article Trainee

N N V Satish&co

Hyderabad

CA Inter

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 12 March 2026
Customer Relationship Executive

TAXLET

Calicut

B.Com

View Details
Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details
Company
Featured 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details