In this tutorial, you will learn how to create hyperlinks in Google Sheets.
How To Create Hyperlinks In Google Sheets
Hyperlinks are an effective way to make your spreadsheet data more interactive and easier to navigate. Google Sheets allows you to easily create links to other sheets, ranges, and external websites.
For example, you can link to another sheet in your spreadsheet, so that users can quickly jump to another page with one click. Or, you may wish to link to external websites relevant to the current dataset.
In this guide, we will show you how to create hyperlinks in Google Sheets to link to other ranges, sheets, and external URLs.
How to Add a Hyperlink in Google Sheets.
Here’s how to add a hyperlink in Google Sheets.
First, we’ll create a hyperlink that links to an external URL.
Click on the cell you want to convert into a hyperlink.
Write down the text you want the hyperlink to display.
In the Insert menu, click on the Link option. Alternatively, we can use the Ctrl+K keyboard shortcut.
A pop-up will appear prompting you to provide the desired URL. After typing the valid URL, click on Apply to proceed.
The text in the selected cell should now be formatted as a hyperlink.
In our example, we’ve created a hyperlink to the Google homepage.
We can also create a hyperlink to another sheet.
After typing Ctrl+K while the target cell is selected, click on “Sheets and named ranges” in the pop-up dialog box.
Click on the sheet you want the hyperlink to redirect the user to.
In this example, we want the user to be redirected to Sheet2 when they click on the link.
We can also choose the option ‘Select a range of cells to link’.
Users who click on this hyperlink will be redirected to a particular range within the current sheet.
This guide should be everything you need to create hyperlinks in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.