How to Create a Hyperlink in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on November 30, 2023

This tutorial demonstrates how to create a hyperlink in Excel and Google Sheets.

create a hyperlink webpage 3

Create a Hyperlink

Shortcut to Create a Hyperlink

PC Shortcut:Ctrl+K
Mac Shortcut:+K
Remember this shortcut:
K for Hyperlink

See All Excel Shortcuts

Link to a Web Page

Say that in cell B2, you have the text “Google” and want to create a hyperlink that will navigate to the Google homepage.

  1. Right-click the cell where you want to insert the hyperlink (here, cell B2), and choose Link (or use the keyboard shortcut CTRL + K).

create a hyperlink webpage 1

  1. The Insert Hyperlink window opens to the Existing File or Web Page tab. In the Address box, enter the web page you want to navigate to.
    In the Text to display box, enter the text you’ll see in the cell. (If you leave this field empty, the URL is displayed.) Finally, click OK.

create a hyperlink webpage 2

Now, there’s a hyperlink in cell B2. If you position the cursor over the text, you see the URL (https://www.google.com), and if you click on it, the web page opens in your default browser.

create a hyperlink webpage 3

Link to a Workbook Location

Using the link option in Excel, you can also create a hyperlink that takes you to a specific location in the workbook. For example, in cell B2, you can create a link that jumps to cell D2.

  1. Right-click the cell where you want to insert a hyperlink (B2) and choose Link.

create a hyperlink location in workbook 1

 

  1. In the Insert Hyperlink window, (1) go to the Place in This Document tab, in the Type the cell reference box, (2) enter the cell you want to navigate to (D2).
    In the Text to display box, (3) enter the text you’ll see in the cell (D2 value). Then (4) click OK.

Here, you could also choose to link to a specific sheet, or to a defined name range from the workbook.

create a hyperlink location in workbook 2

Now if you click on the text in cell B2, cell D2 is selected.

create a hyperlink location in workbook 3

Other Hyperlinks

If you insert a hyperlink to another file, the linked file opens when you click on the cell. Or you can create a hyperlink to an email address. Then, when you click on the cell, a new email window opens with the recipient from the link.

You can also add hyperlinks with a macro and set the text to display.

Create a Hyperlink in Google Sheets

Link to a Web Page

To insert a hyperlink to a web page in Google Sheets, follow these steps:

  1. Right-click the cell where you want to insert a hyperlink (B2) and choose Insert link (or use the keyboard shortcut CTRL + K).

google sheets hyperlink to web page

  1. In the link box, enter the website you want to link to (https://www.google.com). Then in the Text box, enter the text you’ll see in the cell (Google), and click Apply.

google sheets hyperlink to web page 2

If you position the cursor over cell B2, you’ll see a preview of the site. If you click on it, you’re sent to this web page in your browser.

google sheets hyperlink to web page 3

Link to a Specific Location

Like Excel, Google Sheets lets you create a hyperlink that will take you to a certain location in your spreadsheet. Say you want to have a link, to cell D2, in B2.

  1. First, get the link to the cell you want to link to. Right-click the destination cell (D2) and choose Get link to this cell.

google sheets hyperlink to specific location in file 1

  1. Now, right-click the cell where you want to insert a link (B2) and choose Insert link (or CTRL + K).

google sheets hyperlink to web page

  1. In the address box, paste the link you copied in Step 1 and click Apply.

google sheets hyperlink to specific location in file 2

As a result, if you click on cell B2, you jump to cell D2.

google sheets hyperlink to specific location in file 3

AI Formula Generator

Try for Free

See all How-To Articles