How to make all content visible in a cell – Wrap Text Microsoft Excel

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.

UnWarpped Text
Select the cell(s) to wrap.
ToWarp
click on Home Tab Wrap Text.
We can also see the Microsoft help describing the Wrap Text feature in excel.
WarppedText
That’s it.Now the cell is fully visible in the Excel 2007 file.

How to Convert a Rows to Columns – Columns to Rows in Excel

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.

Copy rows in excel

Step 2 : Click in any empty cell and right click and select  Paste Special option from it.

Paste-Special

Step 3 : A popup could come, from it check Transpose.

Transpose

That’s it.See the result.

Rows to Column

The same steps applies for converting columns to rows.