Multiple Hyperlinks in one Cell (Excel)

Question

I am trying to add multiple hyperlinks to one cell and have them be clickable and take to different places. I can get the 2 hyperlinks in the cell, however they both take to the same place even though the URLs are different. Any ideas?

Answer 1

I second this feature in MS. Google sheets is able to do this and I've been surprised as to how often I need this functionality.

Answer 2

Hello Shakiru,

I was able to do this in Excel about three years ago at my previous job. I was linking different vendors for a product in one cell. I was able to select a text (vendor 1), hyperlink it to one site and then select another text (vendor 2) in the same cell and then hyperlink it to another site.

MS might have removed the feature.

Regards,

Annabelle

Answer 3

Hi Eileenfenick!

In Excel, a single cell can only contain one hyperlink that directs to a specific location. If you try to add multiple hyperlinks to the same cell, they will all point to the same destination by default.

Excel does not provide built-in functionality to have multiple clickable hyperlinks in a single cell with different destinations perhaps a combination of shapes and VBA code can help out.

Best Regards, Shakiru

Answer 4

Interestingly Microsoft has provided that feature in Visio. Maybe in an upcoming version?

Answer 5

I could add 2 hyperlinks in one cell using this formula: =HYPERLINK("link1","text1")&CHAR(10)&HYPERLINK("link2","text2")

But it's remaining as text when I'm trying to add more hyperlinks.