HYPERLINK

Creates a hyperlink inside a cell.

Sample Usage

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

Syntax

HYPERLINK(url, [link_label])

  • url - 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://, and news:// are permitted; others are explicitly forbidden. If another protocol is specified, link_label will be displayed in the cell, but will not be hyperlinked.

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

  • link_label - [ OPTIONAL - url 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 link_label is a reference to an empty cell, url will be displayed as a link if valid, or as plain text otherwise.

    • If link_label is the empty string literal (""), the cell will appear empty, but the link is still accessible by clicking or moving to the cell.

Notes

  • Failure to enclose url (or link_label, 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.

Examples

Creates a hyperlink inside the cell for specified cell_text.

Make a copy

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
9102818785156456414
true
Search Help Center
true
true
true