HomeInternetGoogleGoogle Spreadsheets: Placing a Hyperlink in a Cell

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(“www.tech-recipes.com”,”Tech-Recipes”)

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

LATEST REVIEWS

Recent Comments

error: Content is protected !!