81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

HYPERLINK()

Description

Creates a hyperlink inside a cell.

Common Questions About the HYPERLINK Formula:
- How do I create a HYPERLINK in Google Sheets? You can copy paste a hyperlink into a cell, or construct one with CONCATENATE or JOIN, and wrap it with the HYPERLINK formula.
- What is the difference between Hyperlink, Link, and URL? a URL is an address, a link is something you can click on to go to another site or part of another site. a hyperlink is a link.
- How do I link to a website in a spreadsheet cell? You can use the HYPERLINK formula to link to a website, or a spreadsheet file, or a spreadsheet cell.

How Can the HYPERLINK Formula Be Used Appropriately?
- To quickly create hyperlinks to websites, documents, and other online resources.
- To make a sheet easier to navigate as users can click around to different cells/sheets.

How Can the HYPERLINK Formula Be Commonly Mistyped?
Not including the "HYPERLINK(" text in the formula.  Leaving out the leading "http://" or "https://" text of a url. Also can be mistyped as LINK, or HYPRLINK, or HYPERLNK, or HYPELINK.

What are Some Common Ways The HYPERLINK Formula Is Used Inappropriately?
- Linking to a malicious website.
- Not using the “HYPERLINK” formula at all but instead using =IMAGE or =INDIRECT.

What are Some Common Pitfalls When Using The HYPERLINK Formula?
- Not double checking the formatting of the URL provided.
- Not encoding any non-ascii characters (e.g. ü or ☃) in the link properly.

What are Common Mistakes When Using The HYPERLINK Formula?
- Not wrapping the URL in quotes.
- Not correctly linking to the desired location.

What are Common Misconceptions People Might Have With The HYPERLINK Formula?
- That a link must point to a web page.  (It can point to a range of cells in a sheet, or a tab)
- That the link must be live in order to be effective. 
- That the HYPERLINK formula can be used to download files from the web.

How To Use in Sheets

HYPERLINK(url, [link_label])

External Links

The story behind Sell Daily: How I built a Google Sheet template for powerful words

Here are 366 words to help you sell. These words can be used in tweets, emails, promotions, and even Facebook ads. Sell Daily is a list of words that jumpstarts your promotional muscles. This sheet and this set of words are meant to be used one a day.

4Better Sheets Tutorials

Send daily emails to yourself to master sales every single day. 100% completely free for Better Sheet members.
We're actually gonna go build the dashboard today.
Create a click Edit: Google changed how the redirect is handled. It no longer automatically goes forward, so you will need to add a link for a user to click on again to go to the forwarded link.

3

A fun way to make a sheet look like a mall.

4