Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Upstate, South Carolina, USA
    Posts
    253
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hyperlink Embedded in a Cell (Excel - W2K & 2002)

    Is there a way to embed a hyperlink within the text of a cell? Or must the entire cell be a hyperlink?

    P.S. <img src=/S/smile.gif border=0 alt=smile width=15 height=15> Interesting that Check Spelling questions the spelling of "hyperlink."

    Thanks,
    Al
    "Do or do not do. There is no try." -- Yoda
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

  2. #2
    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: Hyperlink Embedded in a Cell (Excel - W2K & 2002)

    You turn the cell into a hyperlink, not the TEXT (this is different than the way WORD works)

    You can change the FORMATTING of some of the cell so that ONLY a part of it LOOKS like a hyperlink (change color, remove underline, etc), if that meets your needs.

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Upstate, South Carolina, USA
    Posts
    253
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink Embedded in a Cell (Excel - W2K & 2002)

    Thanks. It's really part of the text in a cell that I want to make a hyperlink. For example, I want to make the bolded text below a hyperlink and leave the other text as non-linked text:

    Site C elevation and geographic coordinates
    Al
    "Do or do not do. There is no try." -- Yoda
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

  4. #4
    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: Hyperlink Embedded in a Cell (Excel - W2K & 2002)

    I fail to see the distinction.
    Type the text you want in a cell. Create a hyperlink(ctrl-k, etc). Format the text as you want it. Format the "text" you want to appear as a "link" to underline/blue to look like a link.

    What does it matter that anywhere links. The only downside is only 1 link per cell

    Steve

  5. #5
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Upstate, South Carolina, USA
    Posts
    253
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink Embedded in a Cell (Excel - W2K & 2002)

    The only downside is only 1 link per cell

    Yep, that's the distinction. In my example above, I wanted to different live links (not look-like-links) in the same cell - one to "elevation" and the other to "geographic coordinates."

    Thanks for your patience.
    Al
    "Do or do not do. There is no try." -- Yoda
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

  6. #6
    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: Hyperlink Embedded in a Cell (Excel - W2K & 2002)

    As a workaround:
    You could create very small commandbuttons(that is of no size) that you place under the text and have the buttons act like a hyperlink

    You could add as many buttons into a cell as you like
    Steve

  7. #7
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Upstate, South Carolina, USA
    Posts
    253
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink Embedded in a Cell (Excel - W2K & 2002)

    Interesting possibility. I give it a try and see how it works.

    Thanks,
    Al
    "Do or do not do. There is no try." -- Yoda
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

Posting Permissions

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