Results 1 to 7 of 7
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Underlining Part of a Cell (2003)

    Hi All,
    I am in Excel, and when I try and underline part of the text in a cell, it is displaying only the words as underlined. Any "fixes"?
    Thanks.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Underlining Part of a Cell (2003)

    Works fine for me in 2003 - can you post a sample?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Underlining Part of a Cell (2003)

    Here you go
    Attached Files Attached Files

  4. #4
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Underlining Part of a Cell (2003)

    Are you referring to the lack of underline for the spaces between words?
    If so, you could replace each space (that you want to appear underlined) with _
    Then the entire section is underlined.
    Chuck Reimer
    I'm from the Government and I'm here to help...

  5. #5
    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: Underlining Part of a Cell (2003)

    If you remove the justifed format it works as expected. I presume the mechanics it does for "Justify" and adding "bits" between words to makes the underlining not work as you desire.

    Steve

  6. #6
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Underlining Part of a Cell (2003)

    Steve,

    Good to know. Thanks
    Chuck Reimer
    I'm from the Government and I'm here to help...

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Underlining Part of a Cell (2003)

    The easiest workaround may be to merge the cells and centre them.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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