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 Tutorial Covers
There are two ways to add hyperlinks in Google Sheets:
Let’s have a look at both these methods.
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:
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).
Another way of inserting hyperlinks in Google Sheets is to use the HYPERLINK formula.
Let me quickly cover the syntax of the HYPERLINK function:
Here is the formula that will insert the hyperlink of the Google homepage with ‘Google’ as the link label.
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.
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:
Now when you click on the hyperlink text, it will automatically take you to the specified sheet.
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:
You may also like the following Google Sheets Tutorials useful: