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
