本篇教你如何在Microsoft Excel中创建文件、文件夹、网页或新文档的链接。在Windows和Mac版本的Excel上都可以这样操作。
步骤
方法 1链接到新文件
![](/static/upload/image/20220506/21213106.jpg)
![](/static/upload/image/20220506/21213107.jpg)
![](/static/upload/image/20220506/21213108.jpg)
![](/static/upload/image/20220506/21213109.jpg)
![](/static/upload/image/20220506/21213110.jpg)
![](/static/upload/image/20220506/21213111.jpg)
![](/static/upload/image/20220506/21213112.jpg)
![](/static/upload/image/20220506/21213113.jpg)
方法 2链接到现有文件或网页
![](/static/upload/image/20220506/21213114.jpg)
![](/static/upload/image/20220506/21213115.jpg)
![](/static/upload/image/20220506/21213116.jpg)
![](/static/upload/image/20220506/21213117.jpg)
![](/static/upload/image/20220506/21213118.jpg)
![](/static/upload/image/20220506/21213119.jpg)
![](/static/upload/image/20220506/21213120.jpg)
![](/static/upload/image/20220506/21213121.jpg)
![](/static/upload/image/20220506/21213122.jpg)
方法 3Linking Within the Document
![](/static/upload/image/20220506/21213123.jpg)
![](/static/upload/image/20220506/21213124.jpg)
![](/static/upload/image/20220506/21213125.jpg)
![](/static/upload/image/20220506/21213126.jpg)
![](/static/upload/image/20220506/21213127.jpg)
![](/static/upload/image/20220506/21213128.jpg)
![](/static/upload/image/20220506/21213129.jpg)
方法 4创建电子邮件地址超链接
![](/static/upload/image/20220506/21213130.jpg)
![](/static/upload/image/20220506/21213131.jpg)
![](/static/upload/image/20220506/21213132.jpg)
![](/static/upload/image/20220506/21213133.jpg)
![](/static/upload/image/20220506/21213134.jpg)
![](/static/upload/image/20220506/21213135.jpg)
![](/static/upload/image/20220506/21213136.jpg)
![](/static/upload/image/20220506/21213137.jpg)
小提示
你也可以使用HYPERLINK 函数来插入超链接:在单元格中输入=HYPERLINK(link_location, name),其中“link_location”是文件、文件夹或网页路径,“name” 是显示在超链接中的文本。警告
如果将通过超链接连接到Excel电子表格的文件移动到新位置,那就必须要编辑超链接以包含新文件的位置。
标签:
暂无标签