Windows & Other OS

How to link to cells or spreadsheets in Google Sheets

For an easy way to jump to a range of cells or another worksheet, use hyperlinks. This is ideal for referring to data you can view with one click . Here’s how to link cells and spreadsheets in Google Sheets.

How to link to a group of cells

If you have a large spreadsheet, you may want to link it to a cell group inside of her. This gives you a quick way to get past that group.

Go to the cell where you want to add the link. You can enter text to use as a link here or in the pop-up that will be presented. Otherwise, the group of cells will appear as text.

Click Insert> Insert Link on the menu.

Click Insert, Insert Link

When the window opens, click on “Sheets and Named Ranges” at the bottom.

Click Named Sheets and Ranges

Then scroll down one more time and click “Select a range of cells to link.”

Click Select a range of cells to link

In either of the two steps above, you can add the text you want to link to in the box labeled Text at the top of the window. This is useful if you didn’t enter it in the cell before starting the linking process.

Add text for the link

When the Select a data range window appears, enter the range of cells or drag through the range on your sheet to complete the box. Click OK. »

Select or enter data range

Then you will see your hyperlink in the cell. Select the cell and then click the link that appears in the small pop-up window. It will go straight to the data range you chose.

Linked Cell Range in Google Sheets

How to link to a group of named cells

If you have defined a name for a group of cells , you can also link it. The process is similar to linking to unnamed cells as described above.

Select the cell where you want to add the link, and click Insert> Insert Link from the menu. When the window opens, click on “Sheets and Named Ranges”.

Click Named Sheets and Ranges

In the next pop-up window, scroll down to the Name Ranges section and choose the one you want. You can also add the cell text here if needed.

Select a named range

Then you will see your hyperlink and when you select the cell, you can click the link in the little pop-up window to go to the named cell range.

Linked Named Cell Range in Google Sheets

How to link to another sheet

A more convenient way to hyperlink in Google Sheets is to link to another sheet. This process is even easier than the previous processes for cell ranges.

Select the cell where you want to add the link, and click Insert> Insert Link from the menu. If you see the sheet you want when the window appears, select it. Otherwise, click on “Named Ranges and Spreadsheets.”

Click Named Sheets and Ranges

Then you will see a list of the worksheets in the workbook under Sheets. Just choose the one you want. Again, you can add text on top if you want.

Select sheet

Then you will see the hyperlink and you can click the link in the little pop-up window to go to the sheet.

Linked sheet in Google Sheets

Copy, edit or delete a link

After adding a hyperlink, either to a cell range or sheet, you can copy, edit, or remove the link . Select the cell that contains the link and choose the action to the right of the small pop-up window.

Copy, edit or delete a link

If you use Microsoft Excel in addition to Google Sheets, take a look at how use cross references and named cells in Excel .

RELATED:   10 things to do with your new iPhone

Related posts

Leave a Comment