• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Phones
  • Media Players
  • Banking and Finance
  • Tips
  • Tutorials
  • Computer
AboutDevice Favicon

About Device

About Device Provides Specification, Review, Comparison, Features, Price of Phones and Computers, How To, General Computer Problem Tutorials, Solution, Education, Tips and Tricks with Videos and Images for faster understanding

You are here: Home / Tutorials / How to Link Cells or Spreadsheet in Google Sheets

How to Link Cells or Spreadsheet in Google Sheets

For a powerful spreadsheet tool with great collaboration features, choose Google Sheets. The cloud software from Google helps you to work with and analyse data on the cloud.

Just like Microsoft Excel, it comes bundled with lots of features that makes it easy for you to work on spreadsheet. One of such feature is the hyperlink feature that allows you to navigate quickly to a part of your spreadsheet or another spreadsheet.

In this guide, we show you how to use hyperlinks.

How to Link to a Group of Cells

Linking to a group of cells will come in handy of you have a large spreadsheet. This enables you to quickly navigate within your spreadsheet. Here’s how to do it:

1. Navigate the cell you want to add the link

You can enter text that will serve as link here or in the pop-up window that will be shown. If not, you’ll see the group of cells as text.

2. Click Insert > Insert Link from menu.

3. Once you see the Window opened, select Sheets and Named Ranges at the bottom.

Select Sheets and Named Ranges; Photo by About Device
Select Sheets and Named Ranges; Photo by About Device

4. Next, scroll down and click Select a Range of Cells to Link.

Click Select a Range of Cells to Link; Photo by About Device
Click Select a Range of Cells to Link; Photo by About Device

5. Both steps above can allow you to add the text you want to link to the box. This is great way to enter it in the cell before you start linking.

6. The Select a Data Range window will appear, and you can then enter the cell range. Next click OK.

Enter the Cell range; Photo by About Device
Enter the Cell range; Photo by About Device

The hyperlink will then appear in the cell and you can the click the link in the cell which will take you to the linked cell.

Click to go to Linked Cell; Photo by About Device
Click to go to Linked Cell; Photo by About Device

How to Link to a Named Group of Cells

If a group of cells has a name you’ve defined, you can link it. Here’s how:

1. Select the cell where you want the link to be added and click Insert > Insert Link from the menu.

2. After the window opens, select “Sheets and Named Ranges”

Select Sheets and Named Ranges; Photo by About Device
Select Sheets and Named Ranges; Photo by About Device

3. In the pop-up that appears, go to the Name Ranges section and specify the range you want

The link will then appear in the cell and when you select it, you’ll see a small-pop up which will lead you to the named cell range.

How to Link to Another Sheet

You may want to link to another sheet, and we’ll guide you here. It’s more easier than the above processes. Here’s how:

1. Select the cell you want the link added to and click Insert > Insert Link from the Menu.

2. The sheet you are interested in linking to may appear. If it does, select it. If it doesn’t click Sheets and Named Ranges.

Select Sheets and Named Ranges; Photo by About Device
Select Sheets and Named Ranges; Photo by About Device

3. There will be a list of spreadsheets shown in the workbook below the Sheets. Select the one you wish to link.

Click on spreadsheet you want to link; Photo by About Device
Click on spreadsheet you want to link; Photo by About Device

The hyperlink will then appear and clicking the link in the small pop-up window will take you to the Sheet.

Click hyperlink to take you to linked spreadsheet; Photo by About Device
Click hyperlink to take you to linked spreadsheet; Photo by About Device

Rounding Up…

Going from one part of your spreadsheet to another can be daunting especially if it is a large one. You want to work smartly and that’s why the hyperlink feature was made for you. We hope you found this guide helpful? If you did, kindly leave a comment and don’t forget to share

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

LATEST

  • MTN 5G Broadband Router Data Plans
  • MTN Data Plan, Price and Subscription Codes
  • How to Report a Discord Server
  • 4 Best Product Management Courses
  • 5 Best Golang Courses on Udemy
  • How to Delete your Telegram Account
  • 5 Best Web Browsers for Android 2023
  • 5 Best WiFi Tools for Android 2023
  • 5 Best PHP Courses on Udemy
  • 5 Best JavaScript Courses on Udemy

Footer

About AboutDevice

About Device Provides Specification, Review, Comparison, Features, Price of Phones and Computers, How To, General Computer Problem Tutorials, Solution, Education, Banking and Finance Tips and Tricks with Videos and Images for faster understanding

Disclaimer

Please This is Not Bank Website, This is a Blog and we provide reply based on our knowledge.Please any information shared is at Your Risk.
Checkout Full Disclaimer

Pages

  • About US
  • Contact Page
  • Disclaimer
  • Privacy Policy

Copyright © 2023