Wrap Text is a feature that shows all information in a cell, even if it appears to overflow into the adjacent cell. Microsoft Excel can wrap text so that it looks neat and professional. You can format the cell so the text wraps automatically, or enter a manual line break.

How it works – Data in the cell wraps to fit the column width, so if you change the column width, data wrapping adjusts automatically. If all wrapped text is not visible, it may be because the row is set to a specific row height or that the text is in a range of cells has been merged.

A text wrap manual break gives you greater control of where the text should be split.  Here’s how –

To add a manual line break  type the text and then pres (keyboard) Alt + Enter wrap text command

The Wrap Text command is accessible on the Ribbon or by using the dialogue box.

The Ribbon: Click the Home tab, Alignment group, then click Wrap Text

The Dialogue Box: Click the Home tab, Alignment group, then click the launcher button.

Generally in the later versions of Excel the row height will automatically increase with the wrap text command. If this does not happen then you can manually set a row height.
In the sheet row: Clicking on the bottom border of a row header and drag the separator or double click the bottom border of a row header.
The Ribbon: Click the Home tab, Cells Group click the Format down arrow then click Row Height

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.