Last Updated on October 31, 2023 by Jake Sheridan
In this tutorial, you will learn 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.
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.
More Google Sheets collaborations:
- Insert Google Sheets Into Google Docs
- Insert Google Sheets Into Google Slides
- How To Share Google Sheets
- How To Comment
- Share Only One Sheet
- How To Access
- How To Save
- How To Give Access
- See Edit History
- How To Use Google Sheets Offline
- Track Changes
- Turn Off Overwrite
- How To Chat
- How To Tag Someone
- How To Share Only One Tab
- How To Collaborate
- Make A Google Sheet View Only
- Add Note
- Add Comment
- Link To Cells Or Spreadsheets
- How To Link Google Sheets
- Link Google Sheets Together
- Reference Another Sheet
- Unlink Form
- How To Hyperlink
- Link Cells
- Reference Cells
- Use Dynamic Cell References
- Use Absolute Cell References