Results 1 to 9 of 9
  1. #1
    5 Star Lounger
    Join Date
    Jun 2001
    Location
    USA
    Posts
    708
    Thanks
    48
    Thanked 1 Time in 1 Post

    Wrap text in a cell whose column is too short (2002 SP-2)

    Hello:

    In the attached document, I would like to wrap the text of B27 and B30.

    But, instead of the wrapping starting at the end of column B, I would it to start at the end of column G.

    Is this possible?

    Thanks a lot!

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

    Re: Wrap text in a cell whose column is too short (2002 SP-2)

    Select cells B27:G27. Then Format/Cells..., Alignment. Check Merge Cells and Wrap Text. Finally, adapt the height of row 27.

    Similarly for B30:G30.

  3. #3
    5 Star Lounger
    Join Date
    Jun 2001
    Location
    USA
    Posts
    708
    Thanks
    48
    Thanked 1 Time in 1 Post

    Re: Wrap text in a cell whose column is too short (2002 SP-2)

    Thanks, Hans! That worked!

    Just one last thing: adapt the height of row 27, instead of manually moving the row's line, I would like to double-click the line underneath the grid #27.

    Alas, despite that the cell runs onto 2 rows, whenever I double-click underneath grid #27--even if the row is already extended into 2 rows--the row thereby becomes 1 row.

    Do you know how I would make this double-clicking make the row accomodate the height of its text?

    Thanks again!

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

    Re: Wrap text in a cell whose column is too short (2002 SP-2)

    Unfortunately, AutoFit doesn't work if you have merged cells. I don't know a workaround <img src=/S/sad.gif border=0 alt=sad width=15 height=15>. Anyone else?

  5. #5
    5 Star Lounger
    Join Date
    Jun 2001
    Location
    USA
    Posts
    708
    Thanks
    48
    Thanked 1 Time in 1 Post

    Re: AutoFit

    <P ID="edit" class=small>(Edited by Jon_Rick on 24-Mar-03 05:04. Forgot attachment)</P>Actually, AutoFit won't even work on cells that are not merged.

    See row 3 in the attached spreadsheet...

    Thanks again, Hans!

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

    Re: AutoFit

    You're correct, but there is a difference:

    Excel attempts to AutoFit row height for non-merged cells. This fails sometimes, in this case because the width calculations for Italic are slightly off. If you increase the width of column C by 0.14 (the smallest possible amount in the current setting), AutoFit row height works as it should.

    For merged cells, Excel doesn't even try to adjust the row height.

  7. #7
    5 Star Lounger
    Join Date
    Jun 2001
    Location
    USA
    Posts
    708
    Thanks
    48
    Thanked 1 Time in 1 Post

    Re: AutoFit

    Hans,

    Thanks for that info.

    Nonetheless, AutoFit also won't work on rows 15 and 21, both without any merged cells.

    So, if you'll tell me how you determined that column C needed widening, I think I can figure same out for these rows [img]/forums/images/smilies/smile.gif[/img]

    Thanks again!

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

    Re: AutoFit

    On my screen, there is nothing wrong with rows 15 and 21 of Sheet1 in the workbook you attached previously.

    I'm afraid I don't have a general recipe for determing which columns should be widened to prevent incorrect row heights. In row 3, intuition told me it might be column C, but I might as well have been wrong.

  9. #9
    New Lounger
    Join Date
    Apr 2003
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AutoFit

    Jonathan et al,
    I use Word Wrap in merged cells with narrow cols. all the time to make things fit on the screen and the page. To enable Auto Fit for the Row height just fool the system !
    XL thinks the data in a group of merged cells is in the leftmost cell of the group, so that is your starting point. Then use some of the spare space over to the right of your spreadsheet and add a SINGLE extra col (eg AB) to duplicate the info. (data or text) in ALL the merged cols. (eg B - H) using the formula:
    AB12 "=B12"
    Then make sure that the width of col. AB is always equal to the combined width of cols. B thru H. To allow for variable screen zoom size, italics etc, it is better to make AB slighly narrower than the combined original col widths. Then Auto Fit adjusts the height of all cells in AB and, hey presto, the original cols. fit too.
    Not an elegant solution and rather wasteful of resources, but it's simple to use, it works every time and you can do it for however many grouped cols. you have in a spreasdsheet.
    Ray.

Posting Permissions

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