How can I hyperlink a sentence within an Excel document? I have an Excel document where I am trying to insert a web link within a cell. It either allows me to hyperlink the entire cell (and all its content) or not at all. I want the cell to have a link to a website plus additional comments. If I hyperlink the entire cell it also hyperlinks the comments, which I do not want to do. If I highlight the web address and right click or try to "insert" the hyperlink it does not allow me to do it.
______________________________________
opening checking account
Date
Votes
1 comment
-
Jet Reports Historic Posts Probably more of an Excel query than a Jet query but I'll give it a try - I think the best way to do this is using the =Hyperlink formula.
Here's an example of what you're trying to do - in the example below only the 'Google' portion is clickable, the rest of the text is just added into the formula. The one thing I don't know how to do is format the text differently - you'd be stuck with the same formatting for the whole cell (though that does not need to be a blue underline, you can still format the cell)
=HYPERLINK("www.google.com","Google")& " Extra Text Here"
Hope that helps?
Please sign in to leave a comment.