How to Create Hyperlinks in Google Sheets (Step-by-Step Guide)

A hyperlink allows you to quickly access an external webpage or a file/folder in your system. These are widely used in web-pages to link to other sites.

You can also create hyperlinks in Google Sheets so that when you click on it, it will take you to that specific web page.

In this tutorial, I’ll show you how to add hyperlinks in Google Sheets and some cool things you can do with it.

This Article Covers:

How to Add Hyperlinks in Google Sheets

There are two ways to add hyperlinks in Google Sheets:

Using the ‘Insert Menu’
Using the Hyperlink formula.

Let’s have a look at both these methods.

Insert Hyperlinks Using the ‘Insert Menu’

Suppose you have a dataset as shown below, where you want to add hyperlinks to the homepages of these companies:

Here are the steps to add hyperlinks to all these names:

Select the cell in which you want to insert the hyperlink.
Go to the ‘Insert’ Tab.
Click on the ‘Link’ option.
In the dialog box that opens, enter the URL of the link.
Click Apply.

This will insert the hyperlink into the cell. Now when you hover the mouse over the cell, it will show you the link on which you can click and visit the web page (which opens in a new tab).

NOTE: You can also use the keyboard shortcut – Control + K to insert a hyperlink in Google Sheets. As soon as you use this shortcut, it will open the ‘Insert Link’ dialog box.

Insert Hyperlinks Using the HYPERLINK formula

Another way of inserting hyperlinks in Google Sheets is to use the HYPERLINK formula.

Let me quickly cover the syntax of the HYPERLINK function:

HYPERLINK(URL, LINK_LABEL)

URL – this is the URL that you want to insert as the hyperlink. You need to specify the full URL and need to enclose it within double quotes.
LINK_LABEL – this is the text that you would see in the cell. You need to specify the text in double quotes.

Here is the formula that will insert the hyperlink of the Google homepage with ‘Google’ as the link label.

=HYPERLINK("https://www.google.com","Google")

When you hover the mouse over the cell with the hyperlink, it would show you the link on which you can click. When you click on it, it will take you to that web page.

Creating a Hyperlink to a Sheet in the Same Google Sheets Document

You can easily create a hyperlink to another sheet in the same Google Sheets document using the insert link method.

Here are the steps to:

Select the cell in which you want to insert the hyperlink.
Go to the Insert Tab.
Click on the ‘Link’ option.
In the dialog box, click on the ‘Sheets in this spreadsheet’ option.
Select the sheet for which you want to create the hyperlink.
Click Apply.

Now when you click on the hyperlink text, it will automatically take you to the specified sheet.

Creating a Hyperlink to a Range of Cells in Google Sheets

You can also use the same technique showed so far to create a hyperlink to a range of cells in the same sheet or to a different sheet.

Here are the steps:

Select the cell in which you want to insert the hyperlink.
Go to the Insert Tab.
Click on the ‘Link’ option.
In the dialog box, click on the ‘Select a range of cells to link’ option.
Specify the range.
Click Apply.

Sumit

Spreadsheet Expert at Productivity Spot | Website | + posts

Google Sheets and Microsoft Excel Expert.

2 thoughts on “How to Create Hyperlinks in Google Sheets (Step-by-Step Guide)”

ali

November 3, 2020 at 19:06

does not work. i wanted to hyperlink file on my pc to google sheets when i paste nothink happens
Jennifer M

October 21, 2020 at 02:16

Super Helpful! Thanks!

Comments are closed.