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