Tips for excel

1531 views
User Avatar

Audit
47 Points Posted on 20 July 2011

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 Topic
On 20 July 2011 at 15:46 Report
Replies (13)
User Avatar

ACA
1090 Points Posted on 20 July 2011
g00d sharing.... :) thanks....
Reply
On 20 July 2011 at 15:53
User Avatar

One life one Dream
3099 Points Posted on 20 July 2011
Originally posted by : Arvind Sharma
g00d sharing.... :)

thanks....

Reply
On 20 July 2011 at 15:56
User Avatar

Accounts manager-MBA
2530 Points Posted on 20 July 2011

thanks for sharing

Reply
On 20 July 2011 at 17:48
User Avatar

Be Patient Live Life
4813 Points Posted on 20 July 2011
Originally posted by : valji

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

CA
197 Points Posted on 20 July 2011

Thnx for sharing

Reply
On 20 July 2011 at 22:21
User Avatar

Guest

Posted on 20 July 2011
Originally posted by : NIKITA

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

C.A.
60 Points Posted on 21 July 2011

thanks for sharing

Reply
On 21 July 2011 at 00:22
User Avatar

PSA
22 Points Posted on 21 July 2011

thanx frnd.

Reply
On 21 July 2011 at 10:49
User Avatar

Student
42 Points Posted on 21 July 2011

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

Reply
On 21 July 2011 at 11:11
User Avatar

CA-FINAL
3582 Points Posted on 21 July 2011

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

Reply
On 21 July 2011 at 12:04
User Avatar

CA-final
28 Points Posted on 21 July 2011

Thanks for sharin.

Reply
On 21 July 2011 at 12:47
User Avatar

Chief Accounts Officer
25 Points Posted on 21 July 2011

thanks for sharing.small things adds value.

Reply
On 21 July 2011 at 14:38
User Avatar

Be Patient Live Life
4813 Points Posted on 25 July 2011
Originally posted by : valji

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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Recent Topics :

  1. FAST DS 2026 query
  2. Consultation
  3. E-way notices for FY 22-23
  4. Gst file not created
  5. Regarding 3CEB query
  6. Omitted E-Commerce Sales Reported in Table 14 but
  7. Omitted sales shown in GSTR-1 Table 14 but not in
  8. EWAY BILL TAKE OUT OF OTHER COMPAMY
  9. Penalty & late fee for late ITR filing
  10. Business discontinued as Government took possessio

More recent discussions | Post

Related Topics :

Loading

Latest Job Openings

View all
Company
26 September 2026
Chartered Accountant

pushpganga ventures

Pune

CA

View Details
Company
ARTICLESHIP 07 October 2026
Article Assistant

Malhotra Rajesh & Associates

New Delhi

B.Com

View Details
Company
19 September 2026
CA/Semi-CA/BCom

Pravin Sarvaiya

Mumbai

CA Inter

View Details
Company
05 October 2026
Senior Accountant

Vision IT Peripherals Pvt Ltd

Mumbai

B.Com

View Details
Company
20 September 2026
Semi Qualified CA

Navin & Associates

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 16 September 2026
CA Article Trainee

SR BAGAI & Co.

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 18 September 2026
Industrial Trainee

Twenty Point Nine Five Ventures Private Limited

Noida

CA Inter

View Details
Company
ARTICLESHIP 21 September 2026
CA Article Assistant

KK & Company Chartered Accountant

Pune

CA Inter

View Details