Display full text in Excel cell

Pierre Tran

9 years ago

Many Excel newbies are confused by the action of text display in a cell. The text is sometimes displayed at the full longgg to another cell or taken out by another cell.

This Excel Tip will show you how to control the text by “Wrap text” action in Excel.

Before “Wrap text” is turned on, the text is displayed in a long line to another cell or cut off by another cell.

When “Wrap text” is turned on, text in a cell is displayed in multiple lines automatically, depend on width of column.

Please see animate below to know how it works.

How “Wrap text function” works in Excel Sheet.