Is there a way to add a hyperlink to text only and not the entire cell in Excel 2010?
I am only able to insert a hyperlink which affects the entire cell (even white space after the text), but I wish to have it so that a user can click on the non-hyperlinked section of the cell in order to select the cell without activating the hyperlink.
Is this possible (ideally without VB)?
Many thanks.
As an aside, if you have no other fields in the document, you can convert all the hyperlinks to plain text manually by Selecting All and pressing Ctrl+Shift+F9 (unlink fields).
I'm not sure.. I just wrote this, but it acts the same as adding a hyper reference (although you can still select the whitespace of a cell (after the text has finished) and it won't follow the link)
=CONCATENATE("This is your ", HYPERLINK("http://www.google.com","Google"), " link")
Just as a FYI, you can hold ALT key and click on a cell without it opening the URI
I got over this by turning off the "wrap text" from the cell formatting.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With