Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Row height autofit problems (Excel 97 SR2)

    I have inherited a large spreasheet in which the row height AutoFit doesn't seem to be working properly. The rows don't expand enough to fit in all the text - sometimes they seem to cut off just half a line of text and sometimes several lines of text. I don't want to have to resort to manually adjusting the row height, as the column width is likely to vary which would have a knock-on effect on the row-height needed.

    Any ideas on what I can do to fix this, please?

    Thanks

    Ann

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Row height autofit problems (Excel 97 SR2)

    I'm afraid that Excel's text handling leaves a lot to be desired. Text wrap and autofit are far from perfect, and the printed result may differ considerably from what is displayed on screen. If correct formatting of text is really important, perhaps Word is more suitable (but Word isn't very good at performing calculations...)

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Row height autofit problems (Excel 97 SR2)

    If you have merged cells check out <post#=270923>post 270923</post#> for some workarounds

    Also row height is limited to 409. Is this the problem

    And also a "bug/feature" is Only 1,024 characters are displayed in a cell in Excel

    If it something else could you elaobrate on your setup and when the problem occurs.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •