Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    wrap text drives me nuts.

    For instance, cell A1- wraptext box is unchecked. So why doesn't the text flow over into B1 (which is empty).
    Sometimes it does flow over, sometimes it doesn't- I can't figure it.

  2. #2
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: wrap text drives me nuts.

    Are you sure it is not a WYSIWYG problem?
    I often find that text appears to overflow into the next cell but doesn't in print preview or the actual print.
    I suspect this 'effect' also varies from font to font.

    Otherwise - does it vary depending on the alignment of cell A1?

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: wrap text drives me nuts.

    If A is right alligned you will get no wrap text effect in to B. Also ensure that B is actully blank. A space is enough to constitute cell content so no overflow from adjacent cells will show up.

    Andrew C

  4. #4
    Star Lounger
    Join Date
    Mar 2001
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: wrap text drives me nuts.

    I think the problem could have been vertical alignment set to justify. Looks like when it's set to justify text, doesn't overflow even if the wrap text box is unchecked and the next cell is completely blank.

  5. #5
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: wrap text drives me nuts.

    With alignment set to justify, it should wrap the text within the same cell, and expand the size of the row to show all the text- it does for me in Excel 2000 SR-1.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  6. #6
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    140
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: wrap text drives me nuts.

    I had exactly this problem with 1-2 of my workbooks, but could not pinpoint the cause.

    Suspects :
    a) Text result of IF...Then...Else formulas
    [img]/forums/images/smilies/cool.gif[/img] Too many format changes (corruption ?) and/or use of Format Painter

    Remarks:
    1) Make sure you do not have a blank (space) in the adjacent cell.
    2) As workaround I used Format|Cells: Alignment "Center Across Selection" i.e. _not_ the merge cell (icon), as this is calling for trouble.

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: wrap text drives me nuts.

    What Geoff says is quiet correct, when either Horizontal or Vertical alignment is set then the cell will wrap the text regardless of Wrap Text setting. However if the cell formatted to a specific height and that height does not accommodate the wrapped text then only one line will show. Set the Row Height to AutoFit and you should see that the text wraps where alignment is justified..

    Andrew C

Posting Permissions

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