From the course: Google Sheets: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Create a hyperlink in a cell

Create a hyperlink in a cell - Google Sheets Tutorial

From the course: Google Sheets: Advanced Formulas and Functions

Start my 1-month free trial

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…

Contents