You see them everywhere – in various articles that want to link more information or references, even in MS Word documents. Yes, of course, hyperlinks are possible in Google Sheets. It allows you to quickly access a web page and even an external folder or file.
Adding hyperlinks in Google Sheets is very simple. Yet there is more to hyperlinks than meets the eye. Here’s how to add hyperlinks to Google Sheets and how to get the most out of them.
Whether you want to link a particular cell in your spreadsheet to an external link or to a file/folder on your computer, the principle remains the same. However, there are several ways to insert hyperlinks in Google Sheets.
The easiest, but not necessarily the fastest, way to insert a hyperlink is to select the cell you want and go to the Insert in the top menu section and select the tab Link option. On the other hand, you can right-click on the cell in question and go to Insert a link in the drop-down menu. The easiest option here would be to use the CTRL+K shortcut.
Whichever method you choose, the same menu will appear, prompting you to enter an external link to an external website, webpage, or file/folder. Paste the link inside the Link box and select Apply or hit Enter.
Now you will see that the text cell in question has turned blue and there is an underline under it. This means that the text is now linked to a particular online address. To access this webpage/file/folder, hover over the cell and a pop-up window will appear. Click on the link in the pop-up window and a new tab will open in your browser, taking you to the linked destination.
Using the HYPERLINK formula
You can also use a formula to add a hyperlink to any cell in your spreadsheet. It’s definitely not the easiest and easiest way to do it. However, if you practice adding formulas to Google Sheets (which is one of its main advantages), you can also use one to add a hyperlink.
The hyperlink formula is quite simple, “=HYPERLINK([URL], [cell text].” The URL is the exact online address you want the cell to link to. Cell text is whatever you want to display as text in the spreadsheet cell. So if you want, for example, to have a cell entry with the text “Search engine” and you want it to be linked to Google, this is what your function should look like:
The effect of this formula is exactly the same as when binding using the CTRL+K shortcut. Still, the standard hyperlink method doesn’t change the formula in Google Sheets, so there you have it.
Create a hyperlink to another sheet
If you’re working with multiple sheets in a single Google Sheets document (which is more than likely), you might want some information to link to another sheet. Yes, it’s totally doable in Google Sheets, using the hyperlink feature.
To do this, open the hyperlink window using one of the methods mentioned above (the formula method will not work, since both sheets will be under the same URL). In the Link field, you will see the Named sheets and ranges option. Expand it by clicking on it. Here you will be able to select the sheet which you want to hyperlink in the given cell.
Now the text in the selected cell will turn blue and underlined. Hover over it and left-click on the sheet link, and you’ll immediately be taken to that particular sheet in your Google Sheets document. The sheet won’t open in the new tab, but if you want, you can middle-click the link.
Create a hyperlink to another Google Sheets document
No, there is no special option that allows you to hyperlink to another Google Sheets document. It’s much simpler than that, actually. When you think about it, every Google Sheets document has its own URL, right? The entire service is online, and you can ask other people to access the Sheets document, as long as you give them access.
Well, that’s how you can hyperlink a particular Google Sheets cell and it leads to a completely different Google Sheets document. Simply use one of the methods mentioned above and enter the URL of the document in question.
Keep in mind, however, that only users authorized to access the document to which the link leads will be able to access it.
Create a hyperlink to a range of cells
A very useful hyperlink option is where you can set a range of cells to automatically highlight when navigating to a hyperlink in a cell. This is a handy SEO option. It is often used when you want to elaborate on the data inside a cell. For example, let’s say a cell shows how many US athletes are participating in a competition. You can link this cell to lead to the list of names of these athletes in the same spreadsheet. Here’s how to create a hyperlink to a range of cells.
Select a particular cell you want to hyperlink and enter the hyperlink menu as you did before (without using the formula). In the pop-up dialog box, you will see the Select a range of cells to link option. Use typical Google Sheets/MS Excel logic to set the range. To hit Okay then Apply. Now to test this, hover over the hyperlinked cell and select the link. The designated cell range should be highlighted automatically.
Hyperlink in Google Sheets
Although the hyperlink action is simple, you can be quite creative with it. There are different ways to add a hyperlink, and there are different types of things the link itself can lead to. In any case, everything is based more or less on the same philosophy.
Did this guide help you hyperlink to a cell in your Google Sheets document? Did you learn something you didn’t know before? Feel free to add your thoughts or ask questions in the comments section below.