Google Spreadsheets: Placing a Hyperlink in a Cell
Google Spreadsheets allows hyperlinks to be placed into the cells of your spreadsheet. You can either display the entire URL or use a simple title for the link, just follow this tech-recipe:
To display the entire URL:
Simply type the URL into the cell. When this cell is selected, an icon will appear. Clicking on the icon will take the viewer to the URL in a new window.
To display a title instead of the URL:
You will need to use a formula to display the title.
=hyperlink(“URL”,”title”)
(example: =hyperlink(“www.tech-recipes.com”,”Tech-Recipes”)









vijai said on December 3, 2008
thank you, its very useful doing things quickly because of your help.
Joe said on January 24, 2009
Is it possible to hperlink to another page in the same workbook?
Ben said on June 9, 2009
Thanks didnt know about that function :)
wilberfan said on November 19, 2009
Gee, this was the top hit in Google when I did a search on how to embed a hyperlink. I think it should be correct with that kind of ranking!
That comma should be a semi-colon? (With a space on either side?)
(example: =hyperlink(”www.tech-recipes.com” ; ”Tech-Recipes”)
Zadling said on March 19, 2010
Pretty neat trick for Google Spreadsheets. Thanks.
Anastacia Haddon said on August 12, 2010
what about linking to a certain cell within the same spreadsheet (its a huge spreadsheet) – the aim is to get down to that cell in a certain section way down below, faster…
Rein said on September 9, 2010
but it does not work in a published html page, i’m afraid
zs said on October 10, 2010
Anastacia – did you find an answer to how to link to another cell withing the same sheet?
Reinder Otter said on July 21, 2011
I get an error when entering the code; asking for source code or something