How to Insert Hyperlink in Google Sheets (5 Easy Steps)

Give users an easy way to jump to additional information...

Shivam Kumar blogger image
Shivam Kumar
Updated on :

While working on a spreadsheet, you may need to create hyperlinks.

Some users need to link to an external website while others may need to link to a location in the same spreadsheet or to another spreadsheet.

Regardless of the reason, adding hyperlinks in Google Sheets is quite simple & easy.

In this tutorial, you’ll learn how to insert hyperlink in Google Sheets through various ways.

TLDR

How to Insert Hyperlink In Google Sheets?

To insert a hyperlink in Google Sheets, highlight the text you would like to hyperlink > open Insert menu > click on links > enter the URL in the ‘Link’ text box and click on the ‘Apply’ button.

Different Ways to Insert Hyperlinks

There are many different ways to create hyperlink in Google Sheets:

  • Manually type the URL (or copy paste)
  • Using the Insert Menu
  • Using the HYPERLINK function
  • Using the Toolbar Menu
  • Using keyboard Shortcut

Let’s learn about each of these methods.

01. Manually Type the URL

When you manually enter a URL in a cell or copy and paste it into the cell, Google Sheets automatically convert it into a hyperlink.

Here’s how it works:

  1. Double click on a cell where you want to insert the hyperlink.
select cell to enter link
  1. Type the URL and press Enter button on your keyboard. For example, If I type the URL – www.spreadstack.com in a cell and hit enter, it will create a link to our website.
Create hyperlink in Google Sheets

Keep in mind that you need to add HTTP or HTTPS for those URLs where there is no WWW in them. In case there is WWW as the prefix, it would create the hyperlink even without HTTP or HTTPS.

02. Add hyperlink through Insert Menu

If you want the hyperlinked text to be something else other than the actual URL, you can use the insert link feature of Google Sheets.

Here are the exact steps to add a hyperlink in Google Sheets using the Insert Menu:

  1. Select the cell where a hyperlink needs to be inserted. In our example, I am going to select A2
select cell to insert hyperlink
  1. Go to the Insert menu.
open insert menu
  1. Select the Link option from the drop-down menu.
click on link
  1. In the dialog box that opens, enter the URL.
Insert Link in google sheets
  1. Finally, click on the Apply button.
apply hyperlink in google sheets

This will insert the hyperlink in the cell while the text remains the same.

hyperlink inserted in Google Sheets

03. Create Hyperlink using Function

You can also use the HYPERLINK function in Google Sheets to create hyperlinks. This function is particularly helpful when you need to insert multiple links at a time.

The syntax of the HYPERLINK function is:

HYPERLINK(Link_location, [Link_label])

  • Link_location: This is the URL that you want to insert as the hyperlink. You can either enter the URL enclosed in quotation marks, or reference to a cell containing such a URL.
  • Link_label: This is the on-screen name displayed in the cell. You need to specify the text in double quotes.

The ‘link_location’ argument is required, while ‘link_label’ is optional. If the latter is omitted, the ‘link_location’ will be displayed as the link label.

Let’s quickly see the function in action:

  1. Select a cell where you would like to insert the hyperlink. In our example, it is going to be B2
Select the cell to enter function
  1. Type the equal sign = to begin the function and then follow it with the name of the function, which is HYPERLINK
=HYPERLINK
  1. Type an open parenthesis ( or simply hit the Tab key.
=HYPERLINK(
  1. Next enter the URL and enclose it in quotation marks.
URL argument in HYPERLINK function
  1. Type a comma sign , to sperate the first argument and then enter the text you want to display for hyperlink. Don’t forget to enclose it in quotation marks too.
hyperlink function second argument
  1. Finally, enter a closing parenthesis ) and hit enter button on your keyboard.
Hyperlink function in Google Sheets

That’s it…

Insert Link in google sheets using hyperlink function

04. Insert a Hyperlink From the Toolbar

The toolbar is a bar beneath the menu options that lets you carry out the quick commands. You can hover your mouse over each command icon to know what function they perform.

To insert a hyperlink, first, highlight the text you want to hyperlink and then click on the ‘insert link’ icon in the toolbar.

Insert Link button in Google Sheets

Clicking on this icon opens the same dialogue box that you get when you use the Insert menu method.

Insert Link google sheets

Enter the URL and hit apply button.

05. Insert a Hyperlink With Keyboard Shortuct

If all the above steps look like a lot of work to you, you can use a shortcut key for the same task.

Just highlight the text you want to hyperlink and press CTRL + K on your keyboard.

This will open up the insert link dialogue box where you can enter the link and hit apply button.

Insert hyperlink in Google Sheets

So far in this guide, we have only talked about hyperlinking an external website in a Google spreadsheet.

But you can also create hyperlinks to another Google documents, sheets in the same spreadsheet, and even a range of cells in your spreadsheet.

Let’s see how it can be done.

06. Hyperlink to another Google Document

Google Sheets makes it super simple to link to other Google documents like Google Sheet, Doc, Slide, or Form saved in the same Google Drive.

Here’s how it works:

  1. Select the cell or text you would like to hyperlink.
select cell to link google document
  1. Navigate to Insert menu > Link or simply press CTRL + K to open link dialogue box.
open link dialogue box
  1. In the dialogue box that appears, search for the document by typing its name in the ‘Link’ text box. Once found, click on the document name to select it. In our example, I am going to select a Google docs document.
search for google document to hyperlink

That’s it… Now anyone can click on this hyperlink to land on the linked document.

linked google docs in google sheets

07. Hyperlink to sheets in the same spreadsheet

While working with multiple sheets, you have to often refer to data from one sheet to the other. You can use hyperlinks to seamlessly traverse between the sheets.

For example, let’s say I have 4 sheets under a document named “Dashboard”, “January”, “February”, and “March.”

Different sheets

Now I want to link to “February” sheets in one of the cells in “dashboard” sheet.

Here’s how it will work:

  1. Select the cell or text you would like to hyperlink.
select cell to link sheet
  1. Press CTRL + K to open link dialogue box. In the dialogue box that opens, click on the Sheets and named ranges option.
Sheets and Named range google sheets
  1. Next, you’ll be able to choose which sheet you want to hyperlink in the given cell.
select sheets to hyperlink
  1. As soon as you’ll select one of the sheet, selected cell or text will get hyperlinked to the desired sheet.
Linked sheets in google spreadsheet

08. Hyperlinking to a Range of Cells

Navigating through a large dataset can be a nightmare.

You not only have to go through the pain of scrolling through the data every single time but also remember the location of specific datasets within each sheet.

In this situation, hyperlinking a range can be quite helpful.

You can hyperlink a range of cells to easily direct someone to a specific portion of a sheet.

For instance, let’s say that a cell in your spreadsheet tells about how much sales were generated from ‘Texas’ in a quarter.

texas sales number

You can link this cell to actually lead to the month-wise sales number from Texas.

hyperlink range of cells in google sheets

With that said, here’s how to hyperlink to a range of cells:

  1. Select the cell or speicific text you would like to hyperlink.
hyperlink cell range
  1. Press CTRL + K to open link dialogue box. Once the link dialogue box appears, click on the Sheets and named ranges option.
hyperlink sheets and named range
  1. Next, Click on Select a range of cells to link
Hyperlink range of cells
  1. Once the ‘Select a data range’ box appears, select the range of cells using your cursor or manually enter the location of the cell ranges. Then, click on the ‘OK’ button to apply hyperlink.
select a data range to hyperlink

That’s it… Clicking on this hyperlink will lead to the specific cell range.

hyperlink range of cells in google spreadsheet

How to Remove Hyperlink in Google Sheets

Whether you have inserted a link that you no longer want or received a spreadsheet that has irrelevant links. There can be many cases when you would want to remove hyperlinks from a spreadsheet.

Fortunately, it’s very easy.

Simply hover your cursor over the hyperlinked cell or text. A quick view box will appear with a link along with some icons. Click on the remove link icon to get rid of the hyperlink.

Remove Hyperlink in google sheets

NEW TUTORIALS:

Final Thought on Inserting Hyperlinks:

Although adding hyperlinks is a straightforward process, you can get fairly creative with it.

There are various ways to insert hyperlinks and you can link to various types of elements. I hope the tips shared above help you create useful spreadsheets.

Leave a Comment