谁能告诉我hperlink的用法阿

zhenghuaguo

<p>谁能说说和hperlink的用法阿</p><p>特别是在一个工作簿中的两个工作表的使用。</p><p>我查阅EXCEL的帮助文件，它是这样说的：</p><p>You can create hyperlinks within a worksheet to jump from one cell to another cell. For example, if the active worksheet is the sheet named June in the workbook named Budget, the following formula creates a hyperlink to cell E56. The link text itself is the value in cell E56.</p><p><code>=HYPERLINK("[Budget]June!E56", E56)</code></p><p>To jump to a different sheet in the same workbook, change the name of the sheet in the link. In the previous example, to create a link to cell E56 on the September sheet, change the word "June" to "September."</p><p>You can create hyperlinks within a worksheet to jump from one cell to another cell. For example, if the active worksheet is the sheet named June in the workbook named Budget, the following formula creates a hyperlink to cell E56. The link text itself is the value in cell E56.</p><p><code>=HYPERLINK("[Budget]June!E56", E56)</code></p><p>To jump to a different sheet in the same workbook, change the name of the sheet in the link. In the previous example, to create a link to cell E56 on the September sheet, change the word "June" to "September."</p><p>但是我做了就是提示引用失败</p>

knifefox

<p><font face="新宋体">HYPERLINK函数的第一个参数需要完整的路径，比如</font><font face="新宋体">[C:\My Documents\Mybook.xls]sheet1!A1,如果你要实现的超级链接在本工作薄，可以用#代替工作薄的路径。&nbsp; 比如=HYPERLINK("#sheet2!A2") 那么直接链接的本工作薄sheet2工作表 A2单元格。</font></p><p><font face="新宋体">第二个参数就不用多说了。</font></p>

zjxia889

[em01]

djyjysxxs

哈哈，三段的函数2有了1

兰色幻想

<div class="listtitle"><img class="filetype" height="16" src="http://www.excelpx.com/skins/Default/filetype/rar.gif" width="16" alt=""/><a title="《[精英原创]HYPERLINK函数自动链接示例》
作者：兰色幻想
发表于：2007-3-4 16:12:01
最后发贴：谢谢了。这不是..." href="http://www.excelpx.com/forum.php?mod=viewthread&tid=13465" target="_blank"><font color="#000000"> </font><font color="#0000ff">[精英原创]HYPERLINK函数自动链接示例</font><font color="#000000"> </font></a></div><div style="FLOAT: left;">[ </div><div style="FLOAT: left;"><img alt="" src="http://www.excelpx.com/skins/Default/pagelist.gif" style="MARGIN-TOP: 7px;"/></div><div style="FLOAT: left;">&nbsp;<b><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=13465&extra=&page=2"><font color="#ff0000">2</font></a></b> ]</div>