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.

這篇文章實用嗎?
我們應如何改進呢?