When we edit a document, we only need to press theEnterkey on the keyboard to wrap text.

When we editspreadsheets, we press theEnterkey to edit the cells in the next line, then how can we wrap text in a cell? This video could help to solve the problem of Wrap text in a cell and could be also used in Microsoft Office Excel and Openoffice.

The first method is to use the shortcut keyAlt + Enter; we can wrap text in a cell as we need.

The second method is to click theHometabandtheWrap Textbutton. Cell contents will be wrapped automatically according to the column width.

But when we performWrap Texton the text content in the merged cell, we will find that the text content cannot be displayed completely in the merged cell. At this time, we need to expand the line width so that all the text can be displayed.