How to Make a Hyperlink Work in Google Spreadsheets

Save

Google Spreadsheets is a Web-based alternative to Microsoft Excel and other spreadsheet applications. Unlike Excel, Google Spreadsheets does not have a menu button to create a hyperlink out of text in a cell. You have two options for inserting a hyperlink in a Google Spreadsheet: you can directly type a URL, which will automatically become a clickable link, or you can use a hyperlink formula to turn a word or phrase into a clickable link.

  • Open a Google Spreadsheet (google.com/docs).

  • Click inside the cell in which you want to insert a hyperlink.

  • Type or paste a complete URL--beginning with "http://"-- and press "Enter." The URL becomes a clickable link automatically.

  • Paste the following formula to create a text link:

    =hyperlink("http://google.com";"text")

    Replace "http://google.com" with the URL of your link and replace "text" with the link anchor text you want to use. For example, to create a link that says "Click Here to Visit Twitter" that loads twitter.com, paste the following:

    =hyperlink("http://twitter.com";"Click Here to Visit Twitter")

  • Press "Enter" to see your link.

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!