WPS Office
Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Free download
Windows • MacOS • Linux • iOS • Android
Adjust line spacing for text contents in a cell
February 13, 2023
12.6K
Views
52
Can we change the line spacing for texts in a cell to beautify the spreadsheet?
WPS spreadsheets have not supported paragraph settings including adjusting line spacing so far. Even so, we can still adopt some methods to adjust the space between two paragraphs.
· Option 1:
Left-click the cell → click Wrap Text in the Home tab
· Option2:
Double-click between two sentences, and press Alt + Enter on the keyboard.
Also Read:
- 1. How to insert a line break inside a cell in WPS Spreadsheet
- 2. How to adjust line spacing in WPS Writer
- 3. How to add a line in excel cell on Mac
- 4. How to set the line spacing to a fixed value in WPS Writer
- 5. Excel formula: if cell contains text then return value in another cell
- 6. How to adjust the character spacing of slides