Google Spreadsheets: Placing a Hyperlink in a Cell

Contributor Icon Contributed by shamanstears Date Icon December 1, 2006  
Tag Icon Tagged: Google

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”)

Previous recipe | Next recipe |
 
  • vijai
    thank you, its very useful doing things quickly because of your help.
  • Joe
    Is it possible to hperlink to another page in the same workbook?
  • Ben
    Thanks didnt know about that function :)
  • wilberfan
    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”)
blog comments powered by Disqus