在Excel单元格内创建超链接？ [英] Create a hyperlink within an Excel cell?

问题描述

是否可以在Excel单元格内创建一个超链接，该单元格只能使用可点击链接的单元格文本的一部分？ I.E.下面的表模型是否可以在Excel 2010中轻松构建？

Is it possible to create a hyperlink within an Excel cell which only uses a section of the cell text for the clickable link? I.E. would the below table mockup represent something that can be easily built in Excel 2010?

一个模拟http://dl.dropbox.com/u/14119404/misc/Microsoft%20Excel ％20-％20Book1_2012-04-16_14-24-47.jpg

我知道整个单元格可以轻松地制成超链接，但不能根据我所知，细胞的一个特定部分。

I know that an entire cell can be made into a hyperlink easily, but not a specific part of the cell as far as I know.

通过超链接我也参考

• （a）另一个单元格，或


• （b）网址。

谢谢

推荐答案

这在Excel中是不可能的。超链接与整个单元格相关联。

This isn't possible in Excel. Hyperlinks are associated with entire cells.

如果您查看 Excel超链接对象的文档，您可以看到它与一个范围相关联。如果可以将超链接与单元格中的跨度相关联，则超链接对象将需要具有关联的范围，并且字符对象。

If you look at the documentation for the Excel hyperlink object, you can see that it's associated with a Range. If it were possible to associate hyperlinks with a span within the cell, the Hyperlink object would need to have an associated Range and Characters object.

这篇关于在Excel单元格内创建超链接？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！