How to Make a Hyperlink Work in Google Spreadsheets


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 (

  • 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:


    Replace "" 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, paste the following:

    =hyperlink("";"Click Here to Visit Twitter")

  • Press "Enter" to see your link.


Promoted By Zergnet


You May Also Like

Related Searches

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