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.
FAQs on How to Create Hyperlinks in Google Sheets
How to hyperlink part of text in Google Sheets?
Google Sheets now allows you to specify multiple hyperlinks in a single cell. This means you can now link portions of text or add multiple links in a single cell. Simply select the part of the text that you want to hyperlink and click on the ‘Insert link’ icon or CTRL+K from the keyboard. If you’re on a Mac, press Cmd+K instead. You can then specify the location that you want the text to link to.
How to hyperlink to another sheet in Google Sheets?
To hyperlink to another sheet within the same document, follow the steps shown above in the section “Creating a Hyperlink to a Sheet in the Same Google Sheets Document” of this tutorial.
How to dynamic hyperlink in Google Sheets?
If you want to dynamically generate a hyperlink based on a cell reference, you can use the HYPERLINK function as explained here and specify the reference to the cell containing your hyperlink in the first parameter. So if cell A2 contains the dynamic location for your hyperlink, simply use the HYPERLINK formula as shown below:
=HYPERLINK(A2, LINK_LABEL)
Here, replace the LINK_LABEL parameter with the text you want to display as your hyperlink.
If you want to add a value in a given cell to an existing hyperlink, simply add the cell reference with an ampersand (&) to the url string. For example, in the image below, the cell A2 contains a number that you want to add to the end of the URL “www.example.com/”. So your HYPERLINK formula can be:
=HYPERLINK(“www.example.com/”&A2, LINK_LABEL)
This will link to the location “www.example.com/123”
Google Sheets and Microsoft Excel Expert.
-
Sumithttps://productivityspot.com/author/sumitbansal23/
-
Sumithttps://productivityspot.com/author/sumitbansal23/
-
Sumithttps://productivityspot.com/author/sumitbansal23/
-
Sumithttps://productivityspot.com/author/sumitbansal23/
2 thoughts on “How to Create Hyperlinks in Google Sheets (Step-by-Step Guide)”
does not work. i wanted to hyperlink file on my pc to google sheets when i paste nothink happens
Super Helpful! Thanks!
Comments are closed.