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("khobauit.blogspot.com","CNTT")