How to Get Hyperlink from Cell in Google Sheets (4 Quick Tricks)

In Google Sheets, sharing workbooks is really simple. Sharing a section of a sheet or a group of cells can appear important at times. Google Sheets also makes it simple for users to collaborate and save data. It is simple to get a link to a certain cell, range, column, or row. This article will teach you how to use Google Sheets to extract a hyperlink from a cell.

4 Quick Tricks to Get Hyperlink from Cell in Google Sheets

There are actually four quick ways to get a hyperlink from a cell in Google Sheets, depending on the data and circumstance. To demonstrate all the ways, we will use some basic data sets. Each will be shown in the section that follows.

1. Linking to Cell or Cell Range

Getting the URL to a certain portion of a sheet might be quite helpful. We can save the link for later use or share it with a teammate to notify them of a data issue. We can also share the link with an employee to notify them that something needs to be corrected. Look over the instructions below.

dataset for how to get hyperlink from cell in google sheets


  • First, we need to choose the cell(s) we want to utilize as the link source.

  • Click on a cell to choose it individually.
  • To choose a cell range, click the first cell and then move the mouse through the next cells.
  • Choose a column or row by clicking the column or row header.

  • For instance, we have chosen cells from B4 to C9.

selecting range for sharing

  • Now to access the options menu, right-click your mouse.
  • The View more cell actions option is located at the bottom of the menu; choosing it will open an extended menu.
  • To obtain the URL of the range, select Get link to this range.

where to find get link to this range option

  • Following that, a notification will appear informing that the Link copied to the clipboard.

notification after the copy the complete

  • As a consequence, We may now paste the link and send it to our coworkers, teammates, and so on.

Paste after the copy is done

NOTE: Keep in mind that in order for them to view the section of the page containing your link, you will need to share the workbook with them.

Link Structure

The selected cell reference(s) will appear at the end of the URL when you copy and paste the link. If necessary, you can do this to update the cell, range, column, or row directly within the link. Check the example below: (To understand, scroll right and view the whole link)

Cell Link
For cell C5
For range B4:C9

Read More: How to Hyperlink Data to Another Sheet with Formula in Google Sheets

2. Using Copy Link Option

Assume we have a dataset with the official websites of some of the best NBL basketball teams. We’ll utilize the table to retrieve either the official link of the team or the URL of the cell.

data for using copy link option

By using the copy link option from the cell, we can quickly obtain the website of the team. For clarification, look over the instructions listed below.


  • First, we must choose the cell. It is C5 in this instance.
  • When the cell is selected, a preview of the webpage that is linked to it will appear.

how to select cell in google sheets

  • To copy the link, select the Copy Link option.

copy link option in web preview

  • As soon as the URL is copied, the following notification will show up.

link copied notification in google sheets

  • As a result, we can then paste the link to share it with other users for collaborative work.

paste result from copy link

As you can see in the picture, we pasted the URL into a cell, and as proof, the cell also has a clipboard icon in the bottom right corner denoting the pasted result.

Similar Readings

3. Applying Edit Link Option

Using the Edit Link option is one of the simplest ways to obtain a link. From there, we may copy the link and use it to our advantage to share it later. Check the instructions below for more in-depth clarification.

data for using edit link option


  • Once more, we must choose the cell first. C6 in this instance.
  • Choosing the cell will display a preview of the webpage that is linked to it again.

link preview by clicking cell in google sheets

  • In the same fashion, we’ll utilize the Edit link option.

how to access the edit link option in google sheets

  • Thereupon, when we click it, a new window will appear similar to the one below.
  • Hence, We can copy the link that is located directly below the Text bar.

copy link from a cell in google sheets

NOTE:  With the “Ctrl+K” [Windows] or “CMD+K” [Mac] keyboard shortcut, you can jump straight to this window and copy the link.
  • We can paste the link after we’ve copied it so that other users can access it.

paste result from edit link

Once you have finished pasting the URL, as seen in the image above, a clipboard icon will show up. All things considered, this is one method for retrieving a web address or link from a cell in Google Sheets.

4. Using Apps Script

We can get hyperlinks from a cell using the Apps Script feature of Google Sheets. To automate the process, we can create special formulas. Look at the example below.

data for getting a hyperlink in cell


  • First, Select the Apps Script option under the Extensions menu.

how to navigate through extensions to open apps script

  • It will open a new Apps Script window for us. Here, we must first give the project a name. Assume it is “Getting Hyperlink from Cell” in this instance.
  • Lately, we must give the script a name, such as the WebLINK function.

renaming title and apps script

  • Now, Enter the script shown below in the Apps Script console:
function WebLINK(input){
  var spreadsheet = SpreadsheetApp.getActiveSheet();
  var cellrange = spreadsheet.getRange(input);
  var value = cellrange.getRichTextValue();
  var webaddress = value.getLinkUrl();
  return webaddress;
  • Don’t forget to select Save project. Then, Run the script.

apps script save option

  • We shall now return to cell D5 of our active worksheet.
  • To extract the website link from Bulls, we’ll use the following formula.
NOTE: Unlike many Google Sheets formulas, the input needs to be in double quotes.

use of custom formula to get a hyperlink in cell

  • Alternatively, we can use the following formula as well to retrieve the URL from the cell.

alternative formula to get a hyperlink using apps script

  • We can replicate the formula and extract links from other cells using the “Fill handle” feature of Google Sheets. From cell D6 to D9, we shall apply this procedure.

result derived from apps script in google sheets

Read More: How to Extract URL from Hyperlink in Google Sheets (3 Ways)

Final Words

All of the aforementioned techniques are effective. To get a hyperlink from a cell or a range of cells in Google Sheets, use one of these highly effective ways. Given that, there are additional options, such as adding add-ons to extract the link or URL from the cell. I hope that was useful. For more guides on Google Sheets, visit OfficeWheel.

Related Articles

Ishrak Khan

Ishrak Khan

Ishrak Khan is a writer and urban planner born in Dhaka, Bangladesh, one of the largest mega-cities. He is a professional Content Developer closely working with OfficeWheel. He simply likes to enthrall his readers. He loves Football, Nico Robin, Deserts, and Twix. If you like the post, give him a heart on Instagram.

We will be happy to hear your thoughts

Leave a reply