Wrap Text choice in Excel leaves blank space at the bottom, making the report look flawed.

Kioren Moss 0 Reputation points
2026-09-12T22:20:03.95+00:00

When I choose the Wrap Text option in Excel, it leaves blank lines at the bottom that appear on the spreadsheet. This makes the report look flawed. It only happens in one or two of seven worksheets. I have tried everything. What am I missing?

Microsoft 365 and Office | Excel | For home | Windows
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ian-T 11,215 Reputation points Microsoft External Staff Moderator
    2026-09-13T04:20:35.1566667+00:00

    Hi @Kioren Moss

    First, please feel free to check out the AI answer

    Since this happens only on certain worksheets, the blank area may be caused by a saved print area or page break, rather than Wrap Text itself.

    On an affected sheet, try:

    1. Select View > Page Break Preview and check whether a page boundary surrounds the blank area.
    2. Select Page Layout > Breaks > Reset All Page Breaks.
    3. Select Page Layout > Print Area > Clear Print Area.
    4. Return to View > Normal and check the report again.

    Excel calculates page breaks using settings such as paper size, margins, scaling, row height, and column width. A saved print area can also include cells that appear empty.

    Hope this helps, please feel free to let me know if you need any further help.

    Have a nice day!

    Was this answer helpful?

    0 comments

  2. AI answer

    2026-09-12T22:20:14.25+00:00

    The most likely cause is that the affected rows have a fixed row height. When Wrap Text is turned on, Excel wraps the text, but if the row height is manually set, extra blank space or incomplete display can appear.

    Try this on one of the affected worksheets:

    1. Select the cells or rows that show the problem.
    2. Go to Home > Format.
    3. Under Cell Size, select AutoFit Row Height.

    If that fixes it, the issue was the row height setting.

    Also check these conditions called out in Excel guidance:

    • If all wrapped text is not visible, the row may be set to a specific height.
    • If the text is in merged cells, wrapping can also behave unexpectedly.

    If the problem only happens on one or two sheets, compare those sheets for:

    • manually adjusted row heights
    • merged cells in the affected area
    • content pasted into cells before formatting

    If the goal is to control where the text breaks, insert a manual line break inside the cell with Alt + Enter.

    If the blank space appears mainly when printing or exporting to PDF, also review:

    • Page Layout view
    • Page Setup scaling
    • column width and margins

    Excel also does not split a single row across multiple printed pages, so a tall wrapped row can leave blank space at the bottom of a page.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.