本篇wikiHow教你如何在Microsoft Excel中创建文件、文件夹、网页或新文档的链接。在Windows和Mac版本的Excel上都可以这样操作。
步骤
方法 1 的 4:
链接到新文件
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/c\/c0\/Insert-Hyperlinks-in-Microsoft-Excel-Step-1-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-1-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/c\/c0\/Insert-Hyperlinks-in-Microsoft-Excel-Step-1-Version-3.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
1
打开Excel文档。双击要插入超链接的Excel文档。
- 你也可以双击Excel图标,然后点击空白工作簿来打开一个新的文档。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/7\/7f\/Insert-Hyperlinks-in-Microsoft-Excel-Step-2-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-2-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/7\/7f\/Insert-Hyperlinks-in-Microsoft-Excel-Step-2-Version-2.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-2-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
2
选择一个单元格。它应该是要插入超链接的单元格。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/3\/3e\/Insert-Hyperlinks-in-Microsoft-Excel-Step-3-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-3-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/3\/3e\/Insert-Hyperlinks-in-Microsoft-Excel-Step-3-Version-3.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
3
点击插入。这个选项卡位于Excel窗口顶部的绿色带状栏中。点击插入,然后就会在绿色带状栏下方打开一个工具栏。
- 如果你用的是Mac电脑,不要将Excel的插入选项卡和Mac菜单栏中的插入菜单项搞混淆了。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/a\/aa\/Insert-Hyperlinks-in-Microsoft-Excel-Step-4-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-4-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/a\/aa\/Insert-Hyperlinks-in-Microsoft-Excel-Step-4-Version-3.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
4
点击超链接。它位于“链接”部分中插入工具栏的右侧。点击后将打开一个窗口。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/c\/c5\/Insert-Hyperlinks-in-Microsoft-Excel-Step-5-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-5-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/c\/c5\/Insert-Hyperlinks-in-Microsoft-Excel-Step-5-Version-3.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
5
点击新建文档。这个选项卡位于弹出窗口的左侧。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/4\/4d\/Insert-Hyperlinks-in-Microsoft-Excel-Step-6-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-6-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/4\/4d\/Insert-Hyperlinks-in-Microsoft-Excel-Step-6-Version-3.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
6
输入超链接文本。将要显示的文本输入“要显示的文字”字段中。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/9\/95\/Insert-Hyperlinks-in-Microsoft-Excel-Step-7-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-7-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/9\/95\/Insert-Hyperlinks-in-Microsoft-Excel-Step-7-Version-2.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-7-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
7
为新文档输入名称。在“新建文档名称”字段中输入名称。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/4\/49\/Insert-Hyperlinks-in-Microsoft-Excel-Step-8-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-8-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/4\/49\/Insert-Hyperlinks-in-Microsoft-Excel-Step-8-Version-2.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-8-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
8
点击确定。它在窗口底部。默认情况下,这样会创建并打开一个新的电子表格文档,然后在另一个电子表格文档中选定的单元格中创建这个文档的链接。
- 你还可以选择“以后再编辑新文档”选项,然后点击确定创建电子表格和链接,这样就不需要打开电子表格。
方法 2 的 4:
链接到现有文件或网页
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/c\/c9\/Insert-Hyperlinks-in-Microsoft-Excel-Step-9-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-9-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/c\/c9\/Insert-Hyperlinks-in-Microsoft-Excel-Step-9-Version-2.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-9-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
1
打开Excel文档。双击要插入超链接的Excel文档。
- 你也可以双击Excel图标,然后点击空白工作簿来打开一个新的文档。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/7\/7a\/Insert-Hyperlinks-in-Microsoft-Excel-Step-10-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-10-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/7\/7a\/Insert-Hyperlinks-in-Microsoft-Excel-Step-10-Version-3.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-10-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
2
选择一个单元格。它应该是要插入超链接的单元格。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/4\/4c\/Insert-Hyperlinks-in-Microsoft-Excel-Step-11-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-11-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/4\/4c\/Insert-Hyperlinks-in-Microsoft-Excel-Step-11-Version-2.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
3
点击插入。这个选项卡位于Excel窗口顶部的绿色带状栏中。点击插入,会在绿色带状栏下方打开一个工具栏。
- 如果你用的是Mac电脑,不要将Excel的插入选项卡和Mac菜单栏中的插入菜单项搞混淆了。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/4\/49\/Insert-Hyperlinks-in-Microsoft-Excel-Step-12-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-12-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/4\/49\/Insert-Hyperlinks-in-Microsoft-Excel-Step-12-Version-3.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-12-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
4
点击超链接。它位于“链接”部分中插入工具栏的右侧。点击将打开一个窗口。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/d\/d1\/Insert-Hyperlinks-in-Microsoft-Excel-Step-13-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-13-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/d\/d1\/Insert-Hyperlinks-in-Microsoft-Excel-Step-13-Version-3.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-13-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
5
点击原有文件或网页。它在窗口左侧。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/4\/45\/Insert-Hyperlinks-in-Microsoft-Excel-Step-14-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-14-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/4\/45\/Insert-Hyperlinks-in-Microsoft-Excel-Step-14-Version-2.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-14-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
6
输入超链接文本。将要显示的文本输入“要显示的文字”字段中。
- 如果不输入,超链接的文本就会是链接项目的文件夹路径。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/a\/ac\/Insert-Hyperlinks-in-Microsoft-Excel-Step-15-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-15-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/a\/ac\/Insert-Hyperlinks-in-Microsoft-Excel-Step-15-Version-3.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-15-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
7
选择目标地址。点击下列选项卡之一:
-
当前文件夹——在文档或桌面文件夹中搜索文件。
-
浏览过的页——搜索最近浏览过的网页。
-
最近使用过的文件——搜索最近打开的Excel文件。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/9\/99\/Insert-Hyperlinks-in-Microsoft-Excel-Step-16-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-16-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/9\/99\/Insert-Hyperlinks-in-Microsoft-Excel-Step-16-Version-2.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-16-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
8
选择文件或网页。点击要链接的文件、文件夹或网址。文件夹路径将出现在窗口底部的“地址”文本框中。
- 你也可以从互联网上复制一个URL到“地址”文本框中。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/7\/7f\/Insert-Hyperlinks-in-Microsoft-Excel-Step-17-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-17-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/7\/7f\/Insert-Hyperlinks-in-Microsoft-Excel-Step-17-Version-3.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-17-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
9
点击确定。它在页面底部。这样就可以在指定的单元格中创建超链接。
方法 3 的 4:
Linking Within the Document
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/1\/14\/Insert-Hyperlinks-in-Microsoft-Excel-Step-18-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-18-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/1\/14\/Insert-Hyperlinks-in-Microsoft-Excel-Step-18-Version-2.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-18-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
1
打开Excel文档。双击要插入超链接的Excel文档。
- 你也可以双击Excel图标,然后点击空白工作簿来打开一个新的文档。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/0\/0a\/Insert-Hyperlinks-in-Microsoft-Excel-Step-19-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-19-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/0\/0a\/Insert-Hyperlinks-in-Microsoft-Excel-Step-19-Version-3.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-19-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
2
选择单元格。选择应该要插入超链接的单元格。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/6\/6f\/Insert-Hyperlinks-in-Microsoft-Excel-Step-20-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-20-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/6\/6f\/Insert-Hyperlinks-in-Microsoft-Excel-Step-20-Version-2.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-20-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
3
点击插入。这个选项卡位于Excel窗口顶部的绿色带状栏中。点击插入,会在绿色带状栏下方打开一个工具栏。
- 如果你用的是Mac电脑,不要将Excel的插入选项卡和Mac菜单栏中的插入菜单项搞混淆了。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/2\/25\/Insert-Hyperlinks-in-Microsoft-Excel-Step-21-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-21-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/2\/25\/Insert-Hyperlinks-in-Microsoft-Excel-Step-21-Version-2.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-21-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
4
点击超链接。它位于“链接”部分中插入工具栏的右侧。点击将打开一个窗口。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/e\/e6\/Insert-Hyperlinks-in-Microsoft-Excel-Step-22-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-22-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/e\/e6\/Insert-Hyperlinks-in-Microsoft-Excel-Step-22-Version-3.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-22-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
5
点击本文档中的位置。它在窗口左侧。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/a\/ac\/Insert-Hyperlinks-in-Microsoft-Excel-Step-23-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-23-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/a\/ac\/Insert-Hyperlinks-in-Microsoft-Excel-Step-23-Version-3.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-23-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
6
输入超链接文本。将要显示的文本输入“要显示的文字”字段中。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/3\/3b\/Insert-Hyperlinks-in-Microsoft-Excel-Step-24-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-24-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/3\/3b\/Insert-Hyperlinks-in-Microsoft-Excel-Step-24-Version-3.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-24-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
7
点击确定。这样就会在选定的单元格中创建链接。如果点击超链接,Excel会自动突出显示带有链接的单元格。
方法 4 的 4:
创建电子邮件地址超链接
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/d\/d2\/Insert-Hyperlinks-in-Microsoft-Excel-Step-25-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-25-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/d\/d2\/Insert-Hyperlinks-in-Microsoft-Excel-Step-25-Version-3.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-25-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
1
打开Excel文档。双击要插入超链接的Excel文档。
- 你也可以双击Excel图标,然后点击空白工作簿来打开一个新的文档。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/2\/26\/Insert-Hyperlinks-in-Microsoft-Excel-Step-26-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-26-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/2\/26\/Insert-Hyperlinks-in-Microsoft-Excel-Step-26-Version-3.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-26-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
2
选择单元格。选择应该要插入超链接的单元格。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/9\/94\/Insert-Hyperlinks-in-Microsoft-Excel-Step-27-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-27-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/9\/94\/Insert-Hyperlinks-in-Microsoft-Excel-Step-27-Version-3.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-27-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
3
点击插入。这个选项卡位于Excel窗口顶部的绿色带状栏中。点击插入,会在绿色带状栏下方打开一个工具栏。
- 如果你用的是Mac电脑,不要将Excel的插入选项卡和Mac菜单栏中的插入菜单项搞混淆了。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/4\/49\/Insert-Hyperlinks-in-Microsoft-Excel-Step-28-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-28-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/4\/49\/Insert-Hyperlinks-in-Microsoft-Excel-Step-28-Version-2.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-28-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
4
点击超链接。它位于“链接”部分中插入工具栏的右侧。点击将打开一个窗口。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/7\/71\/Insert-Hyperlinks-in-Microsoft-Excel-Step-29-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-29-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/7\/71\/Insert-Hyperlinks-in-Microsoft-Excel-Step-29-Version-2.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-29-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
5
点击电子邮件地址。它在窗口左侧。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/0\/04\/Insert-Hyperlinks-in-Microsoft-Excel-Step-30.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-30.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/0\/04\/Insert-Hyperlinks-in-Microsoft-Excel-Step-30.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-30.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
6
输入超链接文本。将要显示的文本输入“要显示的文字”字段中。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/e\/ed\/Insert-Hyperlinks-in-Microsoft-Excel-Step-31.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-31.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/e\/ed\/Insert-Hyperlinks-in-Microsoft-Excel-Step-31.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-31.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
7
输入邮件地址。在“电子邮件地址”字段中输入要超链接的邮件地址。
- 你也可以在“主题”字段中添加预设主题,这样就会使超链接的邮件打开一条带有主题的新的邮件消息。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/5\/5b\/Insert-Hyperlinks-in-Microsoft-Excel-Step-32.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-32.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/5\/5b\/Insert-Hyperlinks-in-Microsoft-Excel-Step-32.jpg\/v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-32.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
8
点击确定。这个按钮在窗口的底部。
小提示
- 你也可以使用HYPERLINK 函数来插入超链接:在单元格中输入=HYPERLINK(link_location, name),其中“link_location”是文件、文件夹或网页路径,“name” 是显示在超链接中的文本。
警告
- 如果将通过超链接连接到Excel电子表格的文件移动到新位置,那就必须要编辑超链接以包含新文件的位置。