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")

就像一个FYI，你可以按住ALT键并单击一个单元格而不打开URI

Just as a FYI, you can hold ALT key and click on a cell without it opening the URI

这篇关于Excel 2010 - 仅限超链接文本&不是整个细胞的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！