Is there a way to add a hyperlink to text only and not the entire cell in Excel 2010?
是否有一种方法只在文本中添加超链接，而不是在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)?
这可能吗(最好没有VB)?
Many thanks.
多谢。
3 个解决方案
#1
5
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
就像FYI一样，您可以按住ALT键并单击一个单元格，而不需要打开URI。
#2
1
I got over this by turning off the "wrap text" from the cell formatting.
通过关闭单元格格式中的“wrap text”，我克服了这个问题。
#3
0
really, if you have wrap text turned on, the whole cell will act as a hyperlink. if you have wrap text turned off, only text will act as a hyperlink.
实际上，如果打开了包装文本，整个单元格将充当超级链接。如果已关闭包装文本，则只有文本作为超级链接。
#1
5
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
就像FYI一样，您可以按住ALT键并单击一个单元格，而不需要打开URI。
#2
1
I got over this by turning off the "wrap text" from the cell formatting.
通过关闭单元格格式中的“wrap text”，我克服了这个问题。
#3
0
really, if you have wrap text turned on, the whole cell will act as a hyperlink. if you have wrap text turned off, only text will act as a hyperlink.
实际上，如果打开了包装文本，整个单元格将充当超级链接。如果已关闭包装文本，则只有文本作为超级链接。