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 |
 

Viewing 1 Comment

 
close Reblog this comment
blog comments powered by Disqus