HYPERLINK

在儲存格內建立超連結。

使用範本

HYPERLINK("http://www.google.com/","Google")

語法

HYPERLINK(網址, [連結標籤])

  • 網址 - The full URL of the link location enclosed in quotation marks, or a reference to a cell containing such a URL.

    • Only certain link types are allowed. http://, https://, mailto:, AIM, FTP, gopher://, telnet://以及新聞 are permitted; others are explicitly forbidden. IFanother protocol is specified, 連結標籤 will be displayed in the cell, but will not be hyperlinked.

    • If no protocol is specified, http:// is assumed, and is prepended to 網址 .

  • 連結標籤 - [ OPTIONAL - 網址 by default ] - The text to display in the cell as the link, enclosed in quotation marks, or a reference to a cell containing such a label.

    • IF 連結標籤 is a reference to an empty cell, 網址 will be displayed as a link if valid, or as plain text otherwise.

    • IF 連結標籤 is the empty string literal (""), the cell will appear empty, but the link is still accessible by clicking or moving to the cell.

附註

  • Failure to enclose 網址 (or 連結標籤 , if provided) in quotation marks will cause an error.

  • Google Sheets automatically converts most valid URL types when typed into a cell without the need to use this function.

範例

Creates a hyperlink inside the cell for specified cell_text.

true
造訪學習中心

您有在公司或學校使用 Google 文件等 Google 產品嗎?快來試試實用的秘訣、教學課程和範本,瞭解如何在不安裝 Office 的情況下處理 Office 檔案、建立動態專案計劃和小組日曆、自動整理收件匣及進行其他作業。

搜尋
清除搜尋內容
關閉搜尋
Google 應用程式
主選單
10162176454563111865
true
搜尋說明中心
true
true
true