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.