Google Spreadsheets: Placing a Hyperlink in a Cell

Contributed by Rob Rogers  
Tagged: Google  

• Tweet

Browse to next tech-recipes article

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

You may also like -

Google Spreadsheets: How To Add Multiple Lines in the Same CellOpenOffice.org Calc: Show Formulas to Verify Your EquationsExcel 2007: Show Formulas to Verify Your EquationsGoogle Spreadsheets: How To Add or Remove Rows and ColumnsExcel: Prevent Conversion of URLs into HyperlinksExcel 2007: Use the Watch Window to Monitor CellsOpenOffice.org Calc: Print Row and/or Column Headings on Every PageExcel 2007: Have Your Data Read Back To You

 

9 Comments -

1. vijai said on December 3, 2008

   thank you, its very useful doing things quickly because of your help.

2. Joe said on January 24, 2009

   Is it possible to hperlink to another page in the same workbook?

3. Ben said on June 9, 2009

   Thanks didnt know about that function :)

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

5. Zadling said on March 19, 2010

   Pretty neat trick for Google Spreadsheets. Thanks.

6. 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…

7. Rein said on September 9, 2010

   but it does not work in a published html page, i’m afraid

8. zs said on October 10, 2010

   Anastacia – did you find an answer to how to link to another cell withing the same sheet?

9. Reinder Otter said on July 21, 2011

   I get an error when entering the code; asking for source code or something

RSS feed for comments on this post. TrackBack URL

Leave a comment -