Last Updated on October 31, 2023 by Jake Sheridan
In this tutorial, you will learn how to link cells in Google Sheets.
How To Link Cells In Google Sheets
Google Sheets has a powerful feature that allows you to link to another cell in the same sheet, or in a different sheet. This can be a great way to save time and streamline your spreadsheet workflow.
For example, let’s say you have a spreadsheet with a list of items, and you want to link each item name to a different cell in another sheet that contains additional information about the particular item.
Another way we can use links is by converting a particular cell value into a hyperlink. This is often useful when you want the user to access an external webpage.
In this guide, we will show you how to link to another cell in Google Sheets and how to convert cell text into a hyperlink.
How To Create a Link to Another Cell or Cell Range In Google Sheets
Here’s how to create a link to another cell or cell range in Google Sheets.
First, we’ll discuss how to add a hyperlink to a cell. Select the cell you want to add a hyperlink to.
In this example, we want to add a hyperlink in cell A1.
Next, select the Link option under the Insert menu.
You may also use the keyboard shortcut Ctrl + K to select this option.
A pop-up will appear next to the target cell. In the first textbox, indicate the text you want to display as the link.
In our current example, we want our hyperlink to use the text ‘Click Here’.
In the next textbox, type or paste the URL you want to redirect the user to if they click on the link.
Click on Apply to proceed.
The target cell should now have a clickable link that redirects the user to the specified URL.
If you select the cell, you may notice that the cell holds a formula. The Insert Link option really just outputs the HYPERLINK function with the URL and text to display as arguments.
Next, we’ll show you how to create a link to another sheet in the same Google Sheets document.
In the same pop-up menu from Step 3, select the option Sheets and named ranges.
You will now see a list of available sheets to choose from. Click on the desired sheet you want to link to.
You should now have a spreadsheet that links to another sheet.
We can also create a link to a specific range of cells. Click on the option Select a range of cells to link.
In this example, we want our link to redirect the user’s cursor to the range F2:F10.
When the user clicks on the link, the entire indicated range will automatically be selected.
This guide should be everything you need to link to cells and cell ranges in Google Sheets.
You may make your own copy of this example spreadsheet to test it out yourself.
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
- Create Hyperlinks
- Reference Cells
- Use Dynamic Cell References
- Use Absolute Cell References