How To Hyperlink In Google Sheets

In this tutorial, you will learn how to hyperlink in Google Sheets.

One of the most powerful features of web-based tools such as Google Sheets is the ability to insert hyperlinks into a spreadsheet and follow them, all without leaving the browser. Whether you want to link to another location on the internet, or another cell in the same spreadsheet, Google Sheets makes it quick and easy to add hyperlinks to your spreadsheet.

Auto Hyperlinks

If you simply want to add a hyperlink and don’t mind having the hyperlink URL displayed in the text, the auto hyperlinking option is the quickest option

Here’s how to use it:

Step 1

Click on a cell and start typing the URL you want to link to

Step 2

Hit enter and the URL will format as link, with blue color and underline

Step 3

To follow the link, hover over the URL, then click on the link in the popup that appears. The linked URL will load in a new tab of your browser

Step 4

You can also add other text to the cell in addition to the URL and the hyperlink will still work

Editing Hyperlinks

If you want to change the text displayed for a hyperlink, add a hyperlink to your spreadsheet as described above, then follow these steps

Step 1

Hover over the hyperlink you want to edit, then click on the Edit pencil icon in the popup

Step 2

Update the text in the Text field, then click Apply

Step 3

The URL portion of the cell text will update

Hyperlink to a Sheet, Range or Cell

In addition to linking to external URLs, you can also link to regions of the current spreadsheet

Here’s how:

Step 1

Click on the cell in which you want to add the hyperlink and open the Insert menu, then choose Link

Step 2

In the Text field, type in the text you want to display for the link

Step 3

In the next field, type in the A1 reference for the cell or range you want to link to. For example, Sheet2!C4 to reference cell C4 on the sheet called Sheet2

Step 4

You can also search for a sheet or named range by name using the second text field, or click on Select a Range of cells to link to select the linked cell(s) with your mouse

Step 5

When you’re done editing the link, click Apply and the link will appear in the cell. Links to other regions of the spreadsheet are formatted the same as links to external sites, and can be followed in the same way

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to hyperlink in Google Sheets. Want more? Check out all the Google Sheets Tutorials.