Fix Excel Adding Blank Space Above Wrapped Text After Autofit
Question details
The user needs a solution to remove unexpected blank space that appears above wrapped text when using the Autofit Row Height function in Excel.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Formatting row heights for wrapped text cells across different zoom levels or print previews.
- Observed behavior
- Excel displays an unexpected gap or blank space at the top of the cell above the wrapped text after applying the autofit row height action.
Ensure that your affected cells do not contain hidden line breaks (Alt+Enter) or trailing spaces at the end of your text, as these will artificially inflate the autofit row height calculation.
Install Latest Office Updates and Test in a New File
Keeping Excel updated and isolating the issue in a new workbook helps identify if the bug is version-specific or tied to a corrupted file.
This rendering issue with autofitted row heights is a known behavior in certain builds of Microsoft 365 Enterprise and Personal. Ensuring your software is completely up to date is the first step in resolving rendering bugs.
Open Excel, navigate to File > Account, click on the Update Options button, and select Update Now to download and install the latest patches from Microsoft.
Open a new blank workbook (Ctrl+N) and type a few lines of wrapped text into a standard cell to act as a control test.
Double-click the bottom boundary of the row heading to trigger Autofit. If the blank space does not appear in the clean file, your original workbook may have hidden formatting issues.

Manually Adjust Row Heights as a Workaround
A reliable, temporary workaround to remove the visual blank space when the automatic autofit calculation fails.
Try WPS Spreadsheet for Flawless Text Wrapping
If Microsoft Excel's autofit rendering bug disrupts your document formatting, WPS Office offers a free, lightweight, and highly compatible alternative. Enjoy seamless text wrapping and precise row height adjustments without frustrating visual glitches.
- 1. Download and Install: Visit the official WPS Office website to download and install the free productivity suite on your computer.
- 2. Open Your Excel File: Launch WPS Spreadsheet, click 'Open', and select your existing .xlsx file that has the formatting issues.
- 3. Apply Accurate Autofit: Select your rows, go to the Home tab, click on 'Rows and Columns', and select 'AutoFit Row Height' to see your text perfectly aligned without extra blank spaces.

Frequently Asked Questions
Why does Autofit Row Height add extra space in Excel?
This is often a rendering issue in certain versions of Microsoft Excel. It frequently occurs due to discrepancies between the screen resolution, zoom level, default printer drivers, and how Excel natively calculates the text bounding box for wrapped text.
Does changing the font size fix the autofit blank space issue?
Sometimes. Excel's autofit calculates height based on the largest font size applied anywhere in the row. If a cell contains hidden characters, a space, or a line break formatted with a larger font size, it creates an unexpected blank gap. Clearing formatting and reapplying a uniform font size can often resolve it.
How do I remove trailing spaces that might be causing row height issues?
You can use the TRIM function to strip extra spaces from your text. Create a helper column, enter '=TRIM(A1)' (assuming A1 contains the problematic text), copy the result, and paste it as 'Values' back into the original cell. Then, reapply the autofit row height.
Does the print preview show the same blank space as the normal view?
Not always. Because Excel relies heavily on your default printer driver to render page layouts, text wrapping and row heights may look perfectly fine in normal view but display unexpected blank spaces in print preview, or vice versa.




