SheetFX
≡
<< Go back to all functions

HYPERLINK

The HYPERLINK function in Google Sheets creates a hyperlink inside a cell. Use this function to link to a web page, a specific location in the sheet, or even to an email address.

Function Syntax and Parameters

Syntax: HYPERLINK(url, [link_label])

Parameters:

  • url: The URL or destination of the hyperlink. It can be a web page address, a sheet tab reference, or an email address.
  • link_label [Optional]: The text that will be displayed as the clickable link. If not provided, the actual URL will be displayed.

Step-by-Step Tutorial

  1. Creating a basic hyperlink:

    • Example: =HYPERLINK("https://www.google.com")
    • Result: Displays the link "https://www.google.com" that redirects to the specified web page.

  2. Customizing link label text:

    • Example: =HYPERLINK("https://www.google.com", "Go to Google")
    • Result: Displays the link label "Go to Google" that redirects to the specified web page.

  3. Creating an email link:

    • Example: =HYPERLINK("mailto:[email protected]", "Send Email")
    • Result: Displays the link label "Send Email" that opens the default email client with a new message to the specified email address.

Use Cases and Scenarios

  1. Referencing external resources: Link to relevant websites or documents within your spreadsheet.
  2. Deep linking within a sheet: Create links that navigate to specific locations within the same sheet.
  3. Email communication: Generate links that open a pre-populated email for quick communication.

Related Functions

  • LINK: Another way to create a hyperlink within a cell.

Related Articles