添加超链接是快速访问电子表格中某些内容的最佳方法之一。您可以链接到单元格、单元格范围、其他工作表,甚至Google 表格(Google Sheets)中的网页。
我们将向您展示如何向工作表添加超链接以及如何删除Google 表格(Google Sheets)中不再需要的链接。
链接到单元格或单元格范围
如果您有一个充满数据的大型Google电子表格,并且想要经常访问单个单元格或单元格范围,您可以轻松创建指向它的链接。
- 选择要放置超链接的单元格。如果单元格包含文本,则该文本将被链接。您还可以在创建链接时添加所需的文本。
- 执行以下操作之一来插入链接:
- 右键单击并选择插入链接。
- 选择工具栏中的
“插入链接”按钮。(Insert Link)
- Choose Insert > Link从菜单中
选择“插入”>“链接” 。

- 当“插入链接”(Insert Link)框出现时,您将在顶部的“文本”(Text)框中看到要链接的单元格内容。如果单元格为空,您可以在该框中输入文本以连接到链接。

- 导航到弹出框的底部并选择“工作表”和命名范围。

- 转到后续屏幕的底部,然后选择选择要链接的单元格范围。

- 在以下对话框中输入以工作表名称开头的单元格引用或单元格范围,或者使用光标选择单元格或范围以自动填充该框。
- 确认单元格或范围并选择“确定”。

然后您将在单元格内看到链接的文本。选择单元格并使用预览中的链接前往单元格或单元格范围。

链接到命名单元格范围
如果您在工作表中
使用命名范围,这将为您提供另一个链接选项。(use named ranges)
- 按照(Follow)上述步骤 1 到 3 选择单元格,打开“插入链接”(Insert Link)框,然后根据需要调整或添加链接文本。
- 转到弹出框的底部并选择“工作表”和命名范围。
- 如有必要,请在框中向下滚动到“命名范围”(Named Ranges)部分的下一个屏幕,然后选择范围。

- 当指向命名范围的链接出现在单元格中时,使用Enter或Return保存它。

如果您在列表中没有看到命名范围,则可能尚未命名。为此,请选择单元格范围,单击鼠标右键,然后选择“查看(View)更多单元格操作”> “定义(Define)命名范围”。

当“命名范围”(Named Ranges)侧边栏出现在右侧时,输入该范围的名称并选择“完成”(Done)。

然后,您可以按照前面的步骤链接到该命名范围。
链接到另一张纸
如果您想链接到Google表格(Sheets)工作簿中的另一个电子表格(link to another spreadsheet),这是在需要时直接跳转到该电子表格的便捷方法。
- 请按照(Follow)之前的步骤 1 至 3 进行操作。
- 转到弹出框的底部并选择“工作表”和命名范围。
- 前往“工作表”(Sheets)部分并选择工作表名称。

- 当工作表的链接出现在单元格中时,使用Enter或Return保存它。

链接到网页
当您想要链接到某个网站或特定网页时,您可以在Google 表格(Google Sheets)中通过几种不同的方法来实现。
使用粘贴操作
在工作表中插入 Web 链接的最简单方法可能是复制并粘贴URL。
- 转到网络浏览器中的地址栏并复制链接。您可以通过选择URL、右键单击并选择“复制”(Copy)来完成此操作。

- 返回Google 表格(Google Sheets)并选择您想要链接的单元格,右键单击并选择“粘贴”(Paste)。

- 然后您将在单元格中看到超链接。如果您想要编辑名称而不是显示URL,请选择用于显示链接预览的单元格,然后选择“编辑(Edit)链接”按钮(铅笔图标)。

- (Enter)在文本框中(Text)输入名称,然后选择应用(Apply)。

使用插入链接功能
链接到站点或页面的另一种方法是使用前面描述的插入链接(Insert Link)功能。
- 选择您想要链接的单元格并执行以下操作之一:
- 右键单击并选择插入链接。
- 选择工具栏中的
“插入链接”按钮。(Insert Link)
- Choose Insert > Link从菜单中
选择“插入”>“链接” 。
- 搜索(Search)、键入链接或将链接粘贴到搜索(Search)或粘贴链接框中。
- (可选)在文本(Text)框中添加或编辑名称,然后选择应用(Apply)。

使用超链接功能
如果您喜欢在 Google 表格中(formulas in Google Sheets)使用函数和公式,您还可以使用HYPERLINK函数插入链接。
公式的语法为“ HYPERLINK (url, label)”,其中仅需要URL 。您可以使用文本的标签参数来链接到URL。请务必将两个参数都包含在引号内。
要插入在线技术提示(Online Tech Tips)的链接,您可以使用以下公式:
=超链接(“https://www.online-tech-tips.com”)

要插入带有标签OTT 的(OTT)在线技术提示(Online Tech Tips)的链接,您可以使用以下公式:
=超链接(“https://www.online-tech-tips.com”,“OTT”)

删除 Google 表格中的超链接
如果您稍后决定删除已添加的超链接或从其他地方导入数据(import data)或工作表并且不想要包含的链接,则可以将其删除。
删除工作表中的单个链接
也许您有一个想要删除的特定超链接。您可以轻松完成此操作。执行以下操作之一来删除单个链接:
选择包含链接的单元格,然后在预览中
选择“删除链接”按钮(断开的链接图标)。(Remove)

右键单击(Right-click)带有链接的单元格,然后移至查看(View)更多单元格操作 >删除(Remove)链接。

超链接已删除,但链接的文本仍保留在单元格中。
删除工作表中的所有链接
也许您的工作表中有很多链接。您不必一次删除一个,而是可以一次性将它们全部处理掉。
- 使用“全选”(Select All)按钮(左上角的正方形)选择整个工作表。您还可以使用键盘快捷键Ctrl + A(Windows上)或Command + A(Mac上) 。

- 右键单击(Right-click)工作表中的任意位置,移至查看(View)更多单元格操作,然后选择删除(Remove)链接。

- 然后,您应该看到工作表中的所有超链接都消失了,但用于链接的任何文本仍然保留。

当您想要快速跳转到另一个单元格、工作表或网页时,您可以通过多种方式在Google 表格(Google Sheets)中添加超链接。
有关其他有用的生产力提示,请查看如何在 Google 表格中使用查找和替换。
How to Add or Remove Hyperlinks in Google Sheets
Adding a hyperlink is one of the best waуs tо acсеss something in your spreаdsheet quickly. Yоu cаn link to a cell, cell range, other ѕheet, and evеn a web page in Google Sheets.
We will show you how to add hyperlinks to your worksheet and remove links in Google Sheets that you no longer want.
Link to a Cell or Cell Range
If you have a large Google spreadsheet full of data and want to visit a single cell or cell range frequently, you can easily create a link to it.
- Select the cell where you want to place the hyperlink. If the cell contains text, that text will be linked. You can also add the text you want when you create the link.
- Do one of the following to insert the link:
- Right-click and pick Insert Link.
- Select the Insert Link button in the toolbar.
- Choose Insert > Link from the menu.

- When the Insert Link box appears, you’ll see the cell contents to be linked in the Text box at the top. If the cell is blank, you can enter text in that box to connect to the link.

- Navigate to the bottom of the pop-up box and pick Sheets and named ranges.

- Go to the bottom of the subsequent screen and pick Select a range of cells to link.

- Either enter the cell reference or cell range starting with the sheet name in the following dialog box or use your cursor to select the cell or range to automatically populate the box.
- Confirm the cell or range and select OK.

You’ll then see the linked text within the cell. Select the cell and use the link in the preview to head to the cell or cell range.

Link to a Named Cell Range
If you use named ranges in your sheet, this gives you another linking option.
- Follow Steps 1 through 3 above to select the cell, open the Insert Link box, and optionally adjust or add the link text.
- Go to the bottom of the pop-up box and pick Sheets and named ranges.
- If necessary, scroll down the next screen in the box to the Named Ranges section and pick the range.

- When the link to the named range appears in the cell, use Enter or Return to save it.

If you don’t see the named range in the list, it’s likely that it wasn’t named already. To do so, select the range of cells, right-click, and pick View more cell actions > Define named range.

When the Named Ranges sidebar appears on the right, enter a name for the range and select Done.

You can then follow the previous steps to link to that named range.
Link to Another Sheet
If you want to link to another spreadsheet in your Google Sheets workbook, this is a handy way to jump right to it when needed.
- Follow Steps 1 through 3 from earlier.
- Go to the bottom of the pop-up box and pick Sheets and named ranges.
- Head to the Sheets section and pick the sheet name.

- When the link to the sheet appears in the cell, use Enter or Return to save it.

Link to a Web Page
When you want to link to a website or a particular web page, you have few different ways to do so in Google Sheets.
Use the Paste Action
Probably the simplest way to insert a web link in your sheet is by copying and pasting the URL.
- Go to the address bar in your web browser and copy the link. You can do this by selecting the URL, right-clicking, and picking Copy.

- Return to Google Sheets and select the cell where you want the link, right-click, and pick Paste.

- You’ll then see the hyperlink in the cell. If you want to edit the name rather than display the URL, select the cell to display the link preview and pick the Edit link button (pencil icon).

- Enter the name in the Text box and select Apply.

Use the Insert Link Feature
Another way to link to a site or page is using the Insert Link feature described earlier.
- Select the cell where you want the link and do one of the following:
- Right-click and pick Insert Link.
- Select the Insert Link button in the toolbar.
- Choose Insert > Link from the menu.
- Search for, type, or paste the link into the Search or paste a link box.
- Optionally add or edit the name in the Text box and select Apply.

Use the HYPERLINK Function
If you like using functions and formulas in Google Sheets, you can also use the HYPERLINK function to insert your link.
The syntax for the formula is “HYPERLINK(url, label)”, where only the URL is required. You can use the label argument for the text to link to the URL. Be sure to include both arguments within quotation marks.
To insert a link to Online Tech Tips, you would use this formula:
=HYPERLINK(“https://www.online-tech-tips.com”)

To insert a link to Online Tech Tips that has the label OTT, you’d use this formula instead:
=HYPERLINK(“https://www.online-tech-tips.com”,”OTT”)

Remove Hyperlinks in Google Sheets
If you decide later to remove hyperlinks you’ve added or import data or a sheet from elsewhere and don’t want the included links, you can remove them.
Remove a Single Link in a Sheet
Maybe you have a particular hyperlink you want to remove. You can do this in a snap. Do one of the following to remove an individual link:
Select the cell containing the link and pick the Remove link button (broken link icon) in the preview.

Right-click the cell with the link and move to View more cell actions > Remove link.

The hyperlink is removed, but the text for the link remains in the cell.
Remove All Links in a Sheet
Perhaps you have many links in your sheet. Rather than remove them one at a time, you can take care of them all in one fell swoop.
- Select the entire sheet using the Select All button (square in the top-left corner). You can also use the keyboard shortcut Ctrl + A on Windows or Command + A on Mac.

- Right-click anywhere in the sheet, move to View more cell actions, and pick Remove link.

- You should then see all hyperlinks in your sheet vanish, but any text you used for the links remain.

When you want a fast way to jump to another cell, sheet, or web page, you can add hyperlinks in Google Sheets in various ways.
For other helpful productivity tips, look at how to use find and replace in Google Sheets.