How to Make a Cell a Hyperlink in Google Spreadsheets

In Google Spreadsheets, a web-based alternative to Microsoft Excel, you can create a hyperlink out of a URL, out of a specific word or phrase, or even out of an entire cell. The disadvantage to making an entire cell a clickable link is that it lacks a call to action; the end user has to physically click on the cell in order to realize it's a hyperlink. You can overcome this by including at least one word, such as "link," within the hyperlinked cell.

Instructions

1. Open a Google Spreadsheet at google.com/docs

2. Click on the cell you want to hyperlink.

3. Type the following into the cell:

   =HYPERLINK("URL","")

   Replace "URL" with the exact URL to which you want to link, preserving the quotation marks. The cell is now a link to that Web address.

4. Insert link anchor text within the second set of quotation marks if you want the linked cell to contain text, such as "Click Here."

Resources

• Google Docs