From the course: Google Sheets: Advanced Formulas and Functions
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Create a hyperlink in a cell - Google Sheets Tutorial
From the course: Google Sheets: Advanced Formulas and Functions
Create a hyperlink in a cell
Th business world is connected, which means that resources can be available within your current workbook, on another computer in your network or on the web. In this movie I will show you how to use the hyperlink function to create links to those resources so you can display them quickly. The contents of this workbook, don't think you're into creating the hyperlink, instead what I want to do is create a formula inside one of the cells to make a clickable link. So, I'll click cell A9 and then type equal. The function I'll use is hyperlink so H-Y-P-E-R-L-I-N-K followed by a left parenthesis. Now I need to enter two bits of information, the first is the URL, that is the Uniform Resource Locator or Web address and the second is the link label. That will be the human readable friendly text that will appear within the cell. If you don't add a link label then Google Sheets will just show the URL itself. So for the hyperlink, I will type in double quotes and then http://www.landonhotel.com…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
(Locked)
Count columns and rows in a range1m 56s
-
(Locked)
Select a value given certain inputs3m 19s
-
(Locked)
Look up a value in a range3m 4s
-
(Locked)
Perform advanced lookup operations4m 35s
-
Look up values based on two criteria3m 7s
-
(Locked)
Create a hyperlink in a cell3m 27s
-
(Locked)
Refer to a cell a specified distance from another cell4m 31s
-
(Locked)
-
-