|
|
Since Google Spreadsheets are created and accessed online, you can include hyperlinks to websites just as you might when creating a webpage.
Links in your spreadsheet can be useful for directly referring to your data sources. By keeping information in a spreadsheet, you maintain the ability to sort and analyze your information while including easy access to your references.
For example, if you were collecting research from all around the web in a structured format, a spreadsheet could store the data and you could add a links to data in a “reference” column. Unlike listing entries in a word processing document, with a spreadsheet you can sort all the entries and perform analysis (such as averages, sums, etc). Anyone viewing your spreadsheet can view your data sources.
Please note: Like the other types of data and cell formatting, links in spreadsheets must be assigned to an entire cell, you cannot have just part of the text inside a cell be hyperlinked.
There are two ways to enter links into a spreadsheet:
- Enter the full URL into a desired cell, and the entire cell will become a hyperlink. This is the quickest way to add a URL to your spreadsheet. With this method, the text inside the cell is the URL.
- Enter the hyperlink formula, and you can specify the URL but assign separate text. Instead of displaying the full link URL in the cell, it can display the specific text you enter.
In this example, the first two links are using the hyperlink formula, and the last has just a URL pasted in.
With either method, whenever this cell is selected, a small "pop-out" icon will appear to the left of the cell. Click on this icon to open a new browser window linking to the included URL.
To use the hyperlink formula, follow these steps:
- Navigate to the cell you wish to edit.
- Double-click the cell, click the cell and press Enter, or click the cell and press F2 to edit.
- Use the hyperlink formula in this format: =hyperlink(“website URL”, “cell text”).
- For example,
=hyperlink(“www.google.com”, “search the web”)
would display the text search the web as a link to www.google.com
|
| |
|
|
 |
|
|
