Excel 2010 - 纯超链接文本 &不是整个单元格 [英] Excel 2010 - Hyperlink Text Only & Not Entire Cell
问题描述
有没有办法在 Excel 2010 中仅向文本添加超链接而不是向整个单元格添加超链接?
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.
这可能吗(最好没有 VB)?
Is this possible (ideally without VB)?
非常感谢.
推荐答案
我不确定.. 我刚写了这个,但它的作用与添加超引用相同(尽管您仍然可以选择单元格的空格(文本完成后),它不会跟随链接)
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")
仅供参考,您可以按住 ALT 键并单击单元格而无需打开 URI
Just as a FYI, you can hold ALT key and click on a cell without it opening the URI
这篇关于Excel 2010 - 纯超链接文本 &不是整个单元格的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!