How to Remove Extra Blank Space After Line Breaks in WPS Spreadsheet Cells
Question details
The user needs to remove unwanted empty space that appears below wrapped text after pressing Alt+Enter inside a spreadsheet cell when row height is set to AutoFit, both on screen and in printouts.

- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Formatting a worksheet where cells contain manual line breaks and wrapped text; row height is set to AutoFit, but extra blank space appears below the last wrapped line.
- Observed behavior
- AutoFit Row Height leaves additional blank space below the final wrapped line, even when cells are not merged, and the extra space also appears in printed worksheets.
Open the affected workbook in WPS Office Spreadsheets and enable row and column headings so you can clearly identify the rows that contain manual line breaks. Check the current vertical alignment, row height, and page setup settings before making changes.
Widen the affected column slightly and reapply AutoFit Row Height
Use this first when the last wrapped line ends at the right margin, because column width is the most common trigger for extra blank space.
When a wrapped line ends exactly at the right margin, the spreadsheet calculation may reserve space for another wrap. Increasing column width so the final line has breathing room usually prevents that extra blank area.
Click the column header of the cell that shows extra space below the wrapped text.
Move the pointer to the right edge of the column header, then drag it right by about 5–10% or until the last wrapped line has clear space from the margin.
Select the affected cells, go to the Home tab, click Format in the Cells group, and choose AutoFit Row Height.
If extra space remains, widen the column a little more and run AutoFit Row Height again.

Set vertical alignment to Top and review page setup
Use this when printed output still shows extra space or when the worksheet layout must stay fixed.
Set row height manually when AutoFit remains inaccurate
Use this for stubborn rows, especially if you are using a Mac or an Excel-compatible workbook where AutoFit still calculates too much height.
Fix extra blank space after line breaks directly in WPS Office Spreadsheets
Open the Excel file in WPS Office Spreadsheets, use the familiar ribbon tools to widen the column, reapply AutoFit Row Height, and set Top alignment so cells display and print cleanly without extra blank space.
- 1. Open the file: Launch WPS Office Spreadsheets and open the .xlsx or .xls file that shows extra space after line breaks.
- 2. Widen the column: Click the affected column header, drag the right edge slightly to the right, and then select the affected cells.
- 3. AutoFit the row: Go to the Home tab, click Format, and select AutoFit Row Height to recalculate the row height.
- 4. Set Top alignment: Right-click the cells, choose Format Cells > Alignment, and set Vertical to Top.
- 5. Check print setup: Open File > Print, and adjust Page Layout margins or scaling if the extra space still appears in print preview.

Frequently Asked Questions
Why does AutoFit leave extra space only after manual line breaks?
Manual line breaks split text into separate wrap lines. If the final wrapped line ends at the right margin, the row height calculation may reserve space for an additional blank line. Widening the column slightly and rerunning AutoFit Row Height usually clears the extra space.
Will the extra space appear when I print the worksheet?
Yes, the extra space can appear on printed pages, especially if scaling or margins add room. Check File > Print, then adjust Page Layout > Page Setup scaling and margins if needed.
Can changing vertical alignment help fix the spacing?
Yes. Select the cells, open Format Cells > Alignment, and set Vertical to Top. This prevents lower alignment from adding apparent blank space below wrapped text.
What should I do if AutoFit is still wrong in Excel for Mac?
Select the row, right-click the row header, choose Row Height, and enter the height manually. In Excel for Mac you can also use a VBA routine to calculate and apply suitable row heights.
Can WPS Office Spreadsheets open and save these formatted Excel files?
Yes. WPS Office Spreadsheets opens .xlsx and .xls files and keeps familiar formatting tools such as AutoFit Row Height, Format Cells, and Page Setup.




