This video will explain how to add hyperlinks to Google Spreadsheets.
When you paste a URL into a cell in Google Spreadsheets, it automatically becomes a hyperlink. However, if you want to add anchor text that you can click to navigate to the URL, you must use a formula.
- Click on the cell to which you would like to add a hyperlink.
- Enter this formula manually (don’t copy/paste): =HYPERLINK( “[URL]” ; “[anchor text]” ), replacing [URL] with the website you wish to navigate to and [anchor text] with the text you want to appear.
For example, typing in =HYPERLINK( “www.google.com” ; “Search Google” ) will create a hyperlink that looks like this: Search Google.