Hey friends here in this blog I describe you about an advantageous feature of Excel 2013 that you can automatically convert rows into columns. You guys think that it is very small feature feature but still it saves your lot of time. Now here question is arise how it works? No problem here i describe you how you can convert rows in to columns in very easy way.
Firstly you need to select the entire table in Excel 2013 which you like to convert to either column or row format.
Now you have to make a right click on table and copy it either by selecting Copy or by using the keyboard shortcut "Ctrl + C".
Here you need to remember that not select the Cut option only choose copy option otherwise your data will gone.
Now you have to choose Paste Special by clicking on Home tab on the top of the window.
In this Paste Special box you need to check the Transpose box and after that click on OK.
Now a new table is displays on your screen with converted form that is rows are converted into columns.
If still you are not able to convert it then go for windows support or if excel of your computer is not work then you need to go for computer doctor to solve your problem.
No comments:
Post a Comment