Here are some interesting Operating system and softwares tips and tricks 4u.JUST CLICK ON THE PICTURE IN THE BLOG FOR ENALARGED VIEW.


Saturday, October 22, 2011

Rotate tables - just swap columns and rows in MS Office Excel 2003,07,10

By Saturday, October 22, 2011 , No comments
                Sometimes after you are done creating tables in Excel, you realize that the columns could be better as rows and vice versa.

            PASTE SPECIAL AND TRANSPOSE:  First select the area whose columns and rows you want to swap.Then right-click the selected area and select ‘Copy’ or ‘Cut’, depending on whether you want to entirely replace the table or create a new one while keeping the original. Ensure that the area where you want to insert the table should be the same as the original. Next, right click and select the option ‘Paste Special’. In the dialog box that you see next, select the option Transpose, which you will find in the right-hand corner. Select ‘Ok’. Excel will now swap columns and rows.


Post a Comment

please write your comment

Note: Only a member of this blog may post a comment.

THE WINDOWS TRICKS Headline Animator