Forum Discussion

exceluser6614's avatar
exceluser6614
Copper Contributor
Oct 23, 2019

Renaming a web hyperlink after linking it from another tab

Hello I am trying to do the following but receiving an error. Any Help would be greatly appreciated.

 

1. On Tab A I have a column of web hyperlinks listed

2. On Tab B I am trying to link a cell to a web hyperlink and rename it to something shorter than the web hyperlink

3. I am successfuly with linking the hyperlink from Tab A to Tab B and when I click on the link it works

4. I want to re-name the hyperlink to a shorter name and when I do that using the Hyperlink function it works but then I go to click on the new hyperlink name and receive an error message. Is this possible to do?

 

My ultimate goal is to have a master tab that houses all of the hyperlinks and have those hyperlinks linked to other tabs in the worksheet. When there is a change to that hyperlink, I can make the change on the master tab and it will automatically make the change on the other tabs. 

Formulas and Functions

8 Replies

  • AAbdou's avatar
    AAbdou
    Copper Contributor
    Oct 23, 2019

    Hi exceluser6614 

     

    I'm not fully understanding your question, however, I want to point out that you the option to name a hyperlinked cell with a different name than the hyperlink itself.

     

    You can right-click on a cell, click on link/ edit link and then you will get to a window like the below:

     

     

     

     

    The area marked in blue is where you can enter a custom name for your hyperlink and the area marked in red is where you can enter the hyperlink itself. after you are done, just click OK.

     

    About the HYPERLINK function, you need to make sure to enter both the address and friendly name arguments between double-quotes.

     

    for example =  HYPERLINK("http://www.ExcelBonanza.com", "Excel Bonanza Website")

     

    Hope that helps.

     

    let me know if that works for you.

     

    Regards,

     

     

    Abdelrahman Abdou,

    Certified Microsoft Excel Expert, Consultant.

    Founder, Owner @ ExcelBonanza.com

     

     

    http://www.excelbonanza.com/ | 

    https://www.linkedin.com/in/abdelrahman-abdou-60240150 | https://www.youtube.com/channel/UC2-D2unZHustY_f6V7cj03Q | https://www.facebook.com/ExcelBonanza/

    • exceluser6614's avatar
      exceluser6614
      Copper Contributor
      Oct 23, 2019

      Thank you for the response! I have tried this and it is not working and also not giving me the option to do a right click and "edit hyperlink". I think it is because I am pulling the hyperlink from another tab vs. just typing it into the cell. In the past I am beginning to think its not possible to do what I am trying. AAbdou 

      • AAbdou's avatar
        AAbdou
        Copper Contributor
        Oct 23, 2019

        Hi exceluser6614 ,

         

        I'm still not fully understanding your problem or what you need to do. If you would be able to post screenshots to explain more that would be great.

         

         

         

        Abdelrahman Abdou,

        Certified Microsoft Excel Expert, Consultant.

        Founder, Owner @ ExcelBonanza.com

         

         

        http://www.excelbonanza.com/ | 

        https://www.linkedin.com/in/abdelrahman-abdou-60240150 | https://www.youtube.com/channel/UC2-D2unZHustY_f6V7cj03Q | https://www.facebook.com/ExcelBonanza/

Resources