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.

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:example@example.com", "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

No related functions available for the HYPERLINK function.

Related Articles

• Working with Hyperlinks and URLs in Google Sheets