Row height auto-adjust is insufficient when using Wrap Text in Excel

Posted on 2011-05-03
Last Modified: 2012-05-11

In Excel (2007), is there a limit to how many lines can be displayed in a cell when using Wrap Text?  If so, can that limit be adjusted?

I just opened a brand new workbook and widened a column (to 163).  I then pasted a text entry with 2050 characters into a cell in that column.  Next I selected all cells and clicked Wrap Text.

The row containing the text auto-adjusted its height but the adjustment was not enough to make the complete entry viewable.  To see how many lines the text actually needed, I pasted it into another cell in the same column and then manually adjusted the height.

I found that whereas 12 lines were needed to display the entire entry, the auto-adjust height was only sufficient to display 7 lines.

Out of curiosity, I repeated the same process with a width setting of 120.  This time the auto-adjust height was enough to display 9 lines of text but manual adjustment revealed that the entry needed 16 lines to be fully displayed.

Is there an explanation as to why the auto-adjust does not increase the height enough to display the complete entry?  Is there a work-around that will eliminate that limitation?

Question by:Steve_Brady
    1 Comment
    LVL 22

    Accepted Solution

    I suspect that Excel is having some trouble interpreting the font.
    Try using a fixed-point font (like  Courier New) to see if you have the same problem.
    If not, try it with other fonts (Arial, Times Roman, etc) to see if the problem persists.
    It may also be having a problem with the font size so maybe drop it down a point from 12 to 11 or up from 8 to 9, for example.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now