If you work in IT, learn how BetterCloud’s Unified SaaS Management platform can help you manage G Suite and other applications. Also, learn how you can 10x your G Suite productivity

Hyperlinking text in Google Sheets has never been easier. In Google Sheets, you can hyperlink your cells in four easy ways.

If making a hyperlink easy wasn’t enough, Google Sheets also handles email addresses very well. If you hyperlink text and use an email address as the link, Google will automatically create a mailto link, which will open up a new compose window with your contact’s address pre-filled when clicked.

From the Google Support Site:

  1. Find and open your spreadsheet.
  2. Click the cell in your spreadsheet where you’d like the link to appear.
  3. Choose from the following options:
  4. Click the “Insert” drop-down menu and select Link.
  5. Click the link icon in the toolbar.
  6. Right click in your spreadsheet and select the Insert link option.
  7. Use the Ctrl + K keyboard shortcut (Cmd + K on a Mac).
  8. In the “Text” field that appears, type or edit the text you’d like displayed in the cell containing the link. Leave this field blank if you want the full URL to be displayed in your spreadsheet.
  9. In the “Link” field, you can either paste a URL or email address, or type in the field to begin a search of relevant links across web content and your Google Drive files. You can also click Find more below the search results to browse additional options.
  10. Click Apply.

Hyperlink text in Google Sheets

Shares

UP NEXT: How to Attach Google Drive Files in Gmail

Leave a Reply

64 Comments on "How to Add a Hyperlink to a Google Sheet"

Notify of
avatar
Sort by:   newest | oldest | most voted
wes
Guest
wes

is there a way for the link to be a ” 1 click ” link directly to the url from the anchor text in the spreadsheet?

David Garretson
Guest

I using a Google Spreadsheet and have a static IP with file servers on our network at work – I want to be able to paste a URL to files on our local fileserver – is there a way to do this in Google Spreadsheets?

Christy
Guest
Christy

I have a column, basically containing account numbers. I have added a hyperlink to each of the account numbers to take me to an external website pulling up their account. My question is, can I still sort the sheet by the number (value) in the cell? As of right now, when I sort by account number, it sorts it in order of the url’s. I hope my question makes sense! Thanks for any input.

Lydi
Guest
Lydi

Is there a way to remove the underline formatting on the link without removing the link? I’d like to add links to almost every cell in the document, and with the underlines it looks really messy.

Pooja
Guest
Pooja

What if I have a list of number that represents a revisopn number and I wanted to create a hyper link to the the list of the revison number such that clicking on that number should take be to the associated description link of that revision?

Angelo Cabrera
Guest
Angelo Cabrera

Hi, if you want to concatenate cell values to the hyperlink use the & string concatenation:

hyperlink(“mailto:john@mail.com?subject=Subject&body=Hi, please check this task: ” & D4;”john@mail.com”);

Pooja
Guest
Pooja

Is it =HYPERLINK(CONCATENATE(“http://revision=”,C2,”.com”), C2)

Is there a way I can replace C2 with this ?

Mike
Guest
Mike

This does not work for me. I receive a parser error.

Gold Cup
Guest

Its working

vimal
Guest
vimal

Hi Google Gooru,

I wanted to know, how can I place a hyperlink in Google spreadsheet which can open a doc or excel file saved on my local computer hard-disk.

Let me know.

JoAnne
Guest
JoAnne

Can I link within a google drive spreadsheet?
I want a 1 word text in column A that is a hyperlink into a celll within that file
Thanks!

Keith
Guest

Can you hyperlink from one sheet to another sheet within the same spreadsheet?

Jesse
Guest
Jesse

Hi I am wondering if links work within embeded spreadsheets? I created a spreadsheet with an image in a cell which is also a link, but when I goto the embded version of that sheet on my webpage, the link is null

any fixes?

Darryl
Guest
Darryl

Do you know of a way to add a mail link without showing the mailto code?

LT4412
Guest
LT4412
When I paste a link into a cell it creates the hyperlink that I want. BUT the dropdown, bubble/comment box displays “Go to link: http://… .pdf – Remove” The link is fine, I don’t want to remove it. And I no longer want to see this dropdown box b/c I’m ready to move on and it is covering the row below it. It is annoying. If I go out of the doc and come back in, it is gone – but I’m adding a lot of links, and don’t want to go out and come back into the doc. And… Read more »
Anne
Guest
Anne

Hi.

Thanks for all of this wonderful advice. I was trying to make a home page with a table of contents to link to other spreadsheet pages within the spreadsheet. I used =hyperlink(“[page URL]”; “[name of page]”. A hyperlink comes up, but when I click on it, a new tab in my browser opens and it takes me to the home page I inserted the hyperlink on, not to the hyperlinked page.

Any suggestions?
Thanks in advance.
Anne

Vanessa Dine
Guest
Vanessa Dine

Hi there:
I have a question about inserting a link in a spreadsheet. I copied and pasted the above code a week ago into my spreadsheet and it worked. Today, I’m trying the same exact thing and the URL doesn’t turn into text. Even when I copied and pasted this: =HYPERLINK( “www.google.com” ; “Search Google” )
It didn’t work. I get this: #ERROR
Did google change something?

Celsus
Guest
Celsus

It’s easy peasy in Excel – impossible in Google spreadsheets ? I have a .xls, the first 20 rows (screenful) of which lists a “table-of-contents” so-to-speak. On clicking one of these cells, the user is immediately transferred to the appropriate location within the same spreadsheet. Is this not possible in Google sites ?

Nate
Guest
Nate

How do you put multiple hyperlinks in the same cell? I have a list of about ten items, and they all must be hyperlinked and be in the same cell.

Amber
Guest
Amber

Is there a way that google can generate the url based on information in other cells? For example I have a name in Column A1 that I want to be the anchor text and the long url in column B1. Is there a way that google spreadsheet and read those and combine them with a formula to make the url with the text from A1 and the website in B1 and put that link in C1?

Rob
Guest
Rob

Hello!
Is there a way to view, in the spreadsheet, the content of the hyperlinks? I mean, other than clicking on the links. There used to be a gadget called ‘Show and Tell Content Player’ that was kind of like a Ui App that basically embedded the URL content in the spreadsheet. You could also click “Next Page” and scroll through viewing multiple links in the spreadsheet. Like this: https://docs.google.com/spreadsheet/ccc?key=0ArE5e4EQFYLodHgxNFlhOW81VnZ6SlFWdWZUNDljd3c#gid=5

But, Google is phasing out gadgets in spreadsheets. Looking for a way to recreate it.

Matt
Guest
Matt

Can I have in a cell 1
( https://docs.google.com/spreadsheet/ccc?key=)

cell 2
0Ar4asIOTSlNZdEprNTFnTW1yQUVTSGhiSHZfTTM4RkE

cell 3
#gid=0

and put it altogether? to make a URL so I can put in a new Key

elvis1
Guest

Hi, how can I possible do a “mass” writing of :

=HYPERLINK( “www.url1.com” ; “My url’s name” )
=HYPERLINK( “www.url2.com” ; “My url’s name” )

Appreciate it

BuderimPaul
Guest
BuderimPaul

Is there a way to automate the GOTO link command so all URL’s in a google sheet can be opened with on command?

rob
Guest

Hi,
I tried the formula you have and I keep getting error: Parse error

I tried the formula that google has in the functions menu. Their’s is a little different. Either way both gave me the same error.

Wondering if it’s me

Tom
Guest
Tom

I was wanting to put links in my spreadsheet that would open files on my Google Drive. I have a monthly budget spreadsheet that I created in Google Docs that has monthly information on multiple credit cards. What I would like to do is create a link for each account that would open that months statement that I have stored on my Google Drive. They are Adobe Acrobat files. Would that be possible?

Nina
Guest

I find this really useful so thanks a lot!

Shakuntala
Guest
Shakuntala

Hi,

When I add hyperlink, it always opens that link in new tab. I want to open that in same tab. How can i achieve this?

Outlaw
Guest
Outlaw

Really helpful…. thanks!

billybobrabbitbaby
Guest
billybobrabbitbaby

Very helpful video, thank you GoogleGooru!!!!!

Viktor Kamarás
Guest
Viktor Kamarás

Hi there,

my question is and I hope you can help me. On mobile divece for example on a tablet if i open a google document in google drive (not from web browser), how can i insert a hyperlink to it.

If there is already a hiperlink in the document i can open it with the “follow link” function, but not able to create a new hyperlink just if I open google drive in a web browser.

Many thanx

Sean
Guest
Sean

Hey, I am trying to add to my hyperlink address. I am scraping a site and instead of it coming up as

“http://thehill.com/blogs/global-affairs/un-treaties/303535-power-called-hillary-clinton-a-monster”

It just comes up as :

“/blogs/global-affairs/un-treaties/303535-power-called-hillary-clinton-a-monster”

Is there anyway I can add http://thehill.com to the beginning of my hyperlinks?

Something Like : hyperlink_(‘http://thehill.com’+B2,C2)

Thank you

KD
Guest
KD

Hi — I am hoping you can help me. I am trying to insert an image (jpg file in Dropbox) into a Google spreadsheet cell. I tried using the formula =image(“URL”) — I tried it both with and without the quotes around the Dropbox URL. I keep getting a #ERROR: Parse Error message.

Does Google have an issue inserting URLs for images stored on Dropbox?

Thanks in advance for any assistance you can provide!

Deb
Guest
Deb

I am tracking registrations on one Google spreadsheet and I would like a copy of that spreadsheet in another workbook that will automatically update when I change the original. Is that possible?
Thanks so much for your time!

Catriona Brown
Guest

Hi – i have created a simple monthly budget for our small business on Google spreadsheet, each tab a different month of income and expenditure. – i want to create a summary page. the summary page will have rows on left of months of the year, columns above of expenses. So, for instance in F10, on summary page, i want the January expenses for transport to appear – how do I link that cell to the relevant cell on the January page?
thanks

The Electronic Caregiver Company
Guest

I’m gone to inform my little brother, that he should also go to see this weblog on regular basis to get updated from most recent news.

chris
Guest

is there any way to create a script that you could paste in the URL, hit enter, then paste in the anchor text, and then have it create the hyperlink in the active cell?

Noah
Guest

I take pleasure in, lead to I found exactly what I used to be looking for.

You’ve ended my 4 day long hunt! God Bless you man. Have
a great day. Bye

tidung wisata
Guest

Thanks for finally writing about >How to add a Hyperlink to a Google Spreadsheet | The Gooru <Loved it!

Angelo Cabrera
Guest
Angelo Cabrera

Hi, if you want to concatenate cell values to the hyperlink use the & string concatenation:

hyperlink(“mailto:john@mail.com?subject=Subject&body=Hi, please check this task: ” & D4;”john@mail.com”);

Emilia
Guest
Emilia

Hi! Can I add the hyperlink to a Logo/picture?

Adrian
Guest
Adrian

Hi Team, very helpful! Is there a way to do an in-text hyperlink? For instance – “You can utilize [this link] to go to tab ABC where…” wherein [this link] would be the only phrase in the cell that is a hyperlink?

Is there a “formula” for typing in a phrase? For instance, some method of nesting?

=TEXTFORMULA( You can utilize (HYPERLINK(“#gid=000000000″,” this link”)) to go to tab ABC)

Barb
Guest
Barb

I want to link a url to an image within google sheets. how can I do that? I know how to set up a link behind a set of words but not an image.

wpDiscuz