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.
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).
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.
You may also like the following Google Sheets Tutorials useful:
- How to Use IMPORTRANGE Function in Google Sheets.
- How to Use IMPORTDATA function in Google Sheets.
- Using Query Function in Google Sheets.
- How to Create a Table of Contents in Google Sheets
FREE EBOOK - GOOGLE SHEETS TIPS
10 Google Sheets Tips that will save you hours every week
