How To Link Cells In Google Sheets

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.

Step 1

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.

Step 2

Next, select the Link option under the Insert menu.

You may also use the keyboard shortcut Ctrl + K to select this option.

Step 3

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’.

Step 4

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.

Step 5

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.

Step 6

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.

Step 7

You will now see a list of available sheets to choose from. Click on the desired sheet you want to link to.

Step 8

You should now have a spreadsheet that links to another sheet.

Step 9

We can also create a link to a specific range of cells. Click on the option Select a range of cells to link.

Step 10

In this example, we want our link to redirect the user’s cursor to the range F2:F10.

Step 11

When the user clicks on the link, the entire indicated range will automatically be selected.

Summary

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.