Formatting Issues

How to Remove Extra Blank Space After Line Breaks in WPS Spreadsheet Cells

Algirdas JasaitisAlgirdas Jasaitis Nov 13, 2026 872 views

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.

How to Remove Extra Blank Space After Line Breaks in WPS Spreadsheet Cells
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the affected column

Click the column header of the cell that shows extra space below the wrapped text.

2
Widen the column slightly

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.

3
Reapply AutoFit Row Height

Select the affected cells, go to the Home tab, click Format in the Cells group, and choose AutoFit Row Height.

4
Check the result

If extra space remains, widen the column a little more and run AutoFit Row Height again.

Widen the affected column slightly and reapply AutoFit Row Height
Fastest fix: This column-width adjustment resolves most cases of extra blank space after manual line breaks without changing the cell content.
Fix row spacing in WPS Spreadsheets

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. 1. Open the file: Launch WPS Office Spreadsheets and open the .xlsx or .xls file that shows extra space after line breaks.
  2. 2. Widen the column: Click the affected column header, drag the right edge slightly to the right, and then select the affected cells.
  3. 3. AutoFit the row: Go to the Home tab, click Format, and select AutoFit Row Height to recalculate the row height.
  4. 4. Set Top alignment: Right-click the cells, choose Format Cells > Alignment, and set Vertical to Top.
  5. 5. Check print setup: Open File > Print, and adjust Page Layout margins or scaling if the extra space still appears in print preview.
Preserves clean row spacing without editing cell contents or deleting line breaks.Opens and saves .xlsx, .xls, and .csv files with Microsoft Excel format compatibility.Familiar Excel-like interface makes Format, AutoFit, Alignment, and Page Setup easy to find.Free WPS Office suite includes Spreadsheets, Writer, and Presentation for everyday editing.
microsoft office alternative - wps office

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.