logo elektroda
logo elektroda
X
logo elektroda
Advanced Search
logo elektroda

Inserting Two Hyperlinks in One Excel Cell for Multiple Movie Titles: A Step-by-Step Guide

DAREK-2 15646 9
ADVERTISEMENT
Treść została przetłumaczona polish » english Zobacz oryginalną wersję tematu
| New topic
  • #1 8967138
    DAREK-2
    Level 16  
    Hello.
    I would like to put two hyperlinks in one Excel cell, in which there are two movie titles (see screenshot), but I haven't found a function that would allow it? Do any of you know how to do this?
  • ADVERTISEMENT
  • ADVERTISEMENT
  • #3 16239788
    DAREK-2
    Level 16  
    @DriverMSG - sorry that after such a long time, but you can add the link again because I have a 404 error?
  • ADVERTISEMENT
  • #4 16240064
    DriverMSG
    Admin of Computers group  
    I corrected the link.
  • #5 16240186
    DAREK-2
    Level 16  
    @DriverMSG - I did not read it, thinking that it has to do with my question, so if you can make a substantive comment on the topic - I will be grateful.
  • ADVERTISEMENT
  • #6 16240206
    DriverMSG
    Admin of Computers group  
    Substantially in the absence of photos, an example?

    Provide a sample Excel sheet in the attachment.
  • #7 16242262
    DAREK-2
    Level 16  
    In Attachment.
    As you can see in the example, although there are two hyperlinks in one cell, only the first one works.
    And I would like the selected ones to be opened after hovering the cursor over a specific one.
    Attachments:
  • Helpful post
    #8 16247084
    Maciej Gonet
    VBA, Excel specialist  
    That is not possible. The hyperlink is assigned to the cell or to another object as a whole, not to a piece of text in the cell. You can only separate these texts into text boxes and put them together into a cell, or leave one hyperlink assigned to the cell, and the rest to text boxes. But it's a lot of fun. Isn't it easier to separate texts into different cells? After all, Excel has enough of them.
  • #9 16247097
    Anonymous
    Level 1  
  • #10 16249710
    DAREK-2
    Level 16  
    @drobok - merging several cells does not give anything, because then Excel sees them as one and if you enter 2 www addresses by default, it sends you to the first hyperlink.
    @-Maciej_ Gonet - maybe it's easier to separate hyperlinks to different cells, but I wanted to be ambitious. ;-)
    Ps. If it is impossible - I close the topic.
| New topic
Report a violation of the law

Topic summary

The discussion revolves around the challenge of inserting two hyperlinks in a single Excel cell for multiple movie titles. Users express frustration over the limitation that only one hyperlink can function per cell, as Excel assigns hyperlinks to the entire cell rather than individual text segments. Suggestions include using text boxes for separate hyperlinks or merging cells, but these methods do not resolve the issue effectively. Ultimately, it is suggested that separating hyperlinks into different cells may be the most practical solution, despite the user's desire for a more ambitious approach.
Summary generated by the language model.
ADVERTISEMENT