Wrap text in a cell

Uploaded time: 2021-08-26 Difficulty: Primary

Wrap text in a cell

Wrap text in a cell

Graphic skills

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

When we edit spreadsheets, we press the Enter key to edit the cells in the next line, then how can wen 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 key Alt + Enter ; we can wrap text in a cell as we need.

WPS_2.gif

 

The second method is to click the Home tab and the Wrap Text button. Cell contents will be wrapped automatically according to the column width.

WPS_3.gif

 

But when we perform Wrap Text on 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. 

WPS_4.gif