Results 1 to 9 of 9
  1. #1
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Cell Formatting (MSO2K)

    I have an Excel cell that's strange... It's nothing but text. But if I enclose it in quotes, it reformats with a blank line at the top. If I remove the quotes, the top blank line disappears. If I put the quotes back in, the line comes back.

    I looked at the formatting and noticed nada. I have other cells formatted the same (Paint Format) that don't do that.

    What is?

    It seems that the first is pasting as a graphic. As stated, without the quotes, all is fine. Put them back in....


    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

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

    Re: Cell Formatting (MSO2K)

    Does you cell have text wrapping on (in the Alignment tab of Format | Cells...)? If so, it is probably a glitch in Excel's wrapping algorithm - it incorrectly decides that the text including the quotes is just a fraction too wide to fit on one line, so it adjusts the height of the cell to allow for a second line, but in fact the text still fits on one line.

  3. #3
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Re: Cell Formatting (MSO2K)

    Hans:

    Yes, if I turn off the wrap, the blank line goes away...

    BUT...

    If I go to another 3-line cell (that is "OK") and turn the wrap off and then back on, it remains OK.

    So , is it that line? How the heck do I fix this?

    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

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

    Re: Cell Formatting (MSO2K)

    You can't really fix this, except temporarily. It is a bug in Excel's word wrap routines. You could widen the column slightly, and autofit the height of the row.

  5. #5
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Re: Cell Formatting (MSO2K)

    Hans:

    Not to beat a point to death, but I'm not sure I'm being clear:

    It's adding the blank line *ABOVE* the text block. When I widen the column, it changes the wrap, true, but the blank line at the top stays there.

    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

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

    Re: Cell Formatting (MSO2K)

    To beat a point to death:

    You could widen the column slightly, and autofit the height of the row - Excel will not do the latter automatically. Select the row, then Format | Row | AutoFit, or double click the lower edge of the row header.

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

    Re: Cell Formatting (MSO2K)

    You can send a request to mswish@microsoft.com.

  8. #8
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Re: Cell Formatting (MSO2K)

    OK, thanks Hans.

    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  9. #9
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Re: Cell Formatting (MSO2K)

    Edited by HansV to reduce oversized screenshot in size.

    Hans:

    I just did (both) and

    "The secret of getting ahead is getting started."

    had a blank line afterward.

    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

Posting Permissions

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