WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android

banner

Wrap text in a cell

Uploaded time: August 26, 2021 Difficulty Beginner

Wrap text in a cell

Wrap text in a cell

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. 

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.