How to create a hyperlink in Google Sheets?

How to create a hyperlink in Google Sheets?

By /

Creating a hyperlink in Google Sheets is a simple process that allows you to insert a clickable link to a website, email address, or specific cell within your spreadsheet. To create a hyperlink, first, select the cell or text that you want to turn into a link. Then, go to the “Insert” menu and select “Link.” In the pop-up window, enter the URL or email address you want to link to and click “Apply.” Your selected cell or text will now be clickable and will direct the user to the designated link when clicked. This feature is useful for adding references, sources, or additional information to your spreadsheet.

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.

[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdDUtS3lESlJpMzU1d0t1NHUxX25VelE&single=true&gid=0&output=html&widget=true” width=”500″]

Make a copy

Cite this article

stats writer (2024). How to create a hyperlink in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-to-create-a-hyperlink-in-google-sheets/

stats writer. "How to create a hyperlink in Google Sheets?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-to-create-a-hyperlink-in-google-sheets/.

stats writer. "How to create a hyperlink in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-to-create-a-hyperlink-in-google-sheets/.

stats writer (2024) 'How to create a hyperlink in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-to-create-a-hyperlink-in-google-sheets/.

[1] stats writer, "How to create a hyperlink in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.

stats writer. How to create a hyperlink in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.

Download Post (.PDF)

Related terms:

  1. How can I use the HYPERLINK function in Excel to create clickable links in my spreadsheet?
  2. How to Extract a URL from a Hyperlink in Excel
  3. How do I extract the URL from a hyperlink in Excel?
  4. How can I create a chart in Google Sheets using data from multiple sheets?
  5. How can I create a pivot table in Google Sheets using data from multiple sheets?
  6. Let’s learn how to do it in Google SheetsHow can we do it in Google Sheets?
  7. How to Create Pivot Table from Multiple Sheets in Google Sheets?
  8. How can I create a pie chart in Google Sheets with an example?
  9. How can I create a Bell Curve in Google Sheets?
  10. How can I create a crosstab in Google Sheets?
Slide Up
x
PDF
Scroll to Top