When we type some long text in a excel column it would overlap the other columns.To avoid this and make the full content visible there is a Microsoft office excel tip.
There are times we need to convert excel rows to columns.Excel inbuilt has a option to do this in easy steps.
Rows to Columns
Step 1 : Select the all rows to be converted as columns and copy them.
Step 2 : Click in any empty cell and right click and select Paste Special option from it.
Step 3 : A popup could come, from it check Transpose.
That’s it.See the result.
The same steps applies for converting columns to rows.