Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    183

    Unanswered: Linking to hyperlink

    How do I create a link from one cell to another cell that contains text including a hyperlink?

    If i type =Links!$A$3 in a cell just gives me the text without the hyperlink.

    The general idea is, that in one sheet, I have a series of reference hyperlinks to some websites, and from other shets, I link to these, so I only have to alter the adresse in one place, without having to change all 80 cells containing the hyperlink.

    Cheers, Trin
    IT squid: networks, servers, firewalls, routers and I dabble a little with SQL-server and Access as well....

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. Go to Insert > Hyperlinks. In the dialog box, on the left you will see "Place in this document". Click on it, select the worksheet on ther right, and then on the right (at the top) you can add the cell reference.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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