When using WPS Auto Wrap, the most common questions are about display results, scope of effect, and whether content changes; this FAQ covers 3 common questions and answers.
FAQ
Why does the row height become taller after I turn on Auto Wrap?
- When Auto Wrap is on, text that exceeds the column width is displayed on multiple lines inside the cell.
- To show the full wrapped content, the related row becomes taller.
- This is a normal display result and does not mean the spreadsheet content has changed.
Will my text be lost after I turn Auto Wrap off?
- No. Turning Auto Wrap off only changes the display mode.
- The text remains in the cell and returns to a single-line display.
- If the content exceeds the column width, the overflow part is cut off on screen, but the full content is still available for editing.
Why does Auto Wrap only work for some cells?
- Auto Wrap applies to the currently selected cell or range.
- If only part of the target area is selected, unselected cells will not change.
- To apply the same setting more broadly, select the full target range first and then tap Auto Wrap.
Glossary
| Term | Definition |
|---|---|
| Auto Wrap | A display setting that automatically places cell text on multiple lines when the content exceeds the current column width. |
| Cell | The basic area in a spreadsheet used to enter and display data. |
| Selected range | A group of cells currently selected so the same edit or formatting action can be applied together. |