Archive for May, 2011

How to Transpose in MS Excell

May 3, 2011 Leave a comment

If You want to change the order of tabular data in MS Excel from vertical to Horizontal or Horizontal to vertical then follow the steps.

Step 1: Copy The Tabular data in excel sheet.

Step 2: Select Paste Special where ever u want to paste in same sheet or another sheet.

Step 3: Enable the ‘Transpose’ option from Paste Special Dialog Box and press ok.

Step 4. Finish. u can check the following video for demonstration.

Categories: MS Excel