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