By adding hyperlinks to your Google Sheets, you will be able to easily access other web pages from your spreadsheet.
You can also hyperlink to other sheets so that it is easier to access other spreadsheets from your file.
In this tutorial, I will show you how to create hyperlinks in Google Sheets.
Table of Contents
To add basic hyperlinks to your spreadsheet, there are four methods I will show:
- Creating a hyperlink with the insert menu
- Right-click method to insert a hyperlink
- Keyboard shortcut to create a hyperlink
- Creating a hyperlink with a formula
One of the simplest methods is to insert a hyperlink through the insert menu. Here are the steps to do this:
1. Click on the cell where you want to add the link
2. In the top menu select Insert, and then in the drop-down menu select Insert link
3. In the dialog box under the “link section” enter the URL that you want to link to. Select Apply when you are finished
You have now created a hyperlink inside the cell. When you bring your mouse over the cell it will show the link that you can click on to visit the webpage:
Right Click to Insert Link
You can also right-click to access the Insert link option. The steps for this method are the same as the previous method except instead of going through the top menu, you simply right click and select Insert link
Keyboard Shortcut to Insert Link
The fastest way to insert a hyperlink is using the keyboard shortcut. Select the cell that you want to create the link on and press CTRL + K on your keyboard.
This will immediately open the “insert link” option and you can put your URL in and select Apply
Another method is to use the built-in HYPERLINK function in Google Sheets.
The syntax of this function is:
- url – the first parameter is the URL that you want to the link created for. The URL has to be in quotation marks, or you can also use cell references
- link_label – this parameter is optional. This is the text that will display on your link. If you don’t use it, it will just use the URL as the display text. Otherwise, you can set a specific desired label
Here is an example of how to use this function in your spreadsheet
You can see with this method I have placed the URL inside quotation marks as the first parameter. In the second parameter, I am just going to use a cell reference.
After entering my function the hyperlink is created inside my designated link label (cell A2)
How to Link to Another Tab
You can link to more than just websites using the first three methods we have covered above. You can also link to other sheets inside your file.
Here I will show you how to create a hyperlink to a different tab/sheet inside your same Google Sheets file.
1. The first step is to select the cell where you want the link to appear and then access the insert link option. You can either use the insert menu, right-click, or press CTRL+K on your keyboard and select Insert link
2. Instead of putting a URL inside the dialog box, if you click on the box, you should see an option for Sheets in this spreadsheet. Select that
3. From here you should see all of the sheets that you currently have in your Google Document. Select the one that you want to link to
4. Select Apply
5. You have now created a link to another sheet within your file. When you hover over it, you should see a popup appear where you can click on it to access the sheet
You can also create a hyperlink to a range of cells in Google Sheets. This is done the exact same way as the previous method except for you select the “Select a range of cells to link” option.
After selecting that option you will have to input your range of cells like this:
After entering your range select OK and then Apply and you will have created your link to a cell range
Creating hyperlinks in your Google Spreadsheet is a very useful skill for keeping your files organized and being able to open other sites and sheets efficiently.
You can see as we have covered here, there are a few different methods to do it, but overall it’s not very difficult to learn.