Hi, my name is Shir and I'm the founder and CEO of shirconsulting.com where we focus on converting the existing data from your business into massive savings and extraordinary profits. Today we're going to learn the basics of Excel. Let's get started.
So what is the hyperlink function in Excel? Well, it let's us create shortcuts to a specific document or location within a document on your computer, from the internet, or on your network server. Let's go through a few examples to understand how it works.
So here, I am going to go through the exact formula. I am going to highlight the cell and I am going to see what's inside of it. So we have the "=" hyperlink function name. The first argument is the link location which in this case I've referenced another cell which has it fully typed out. In the future, I recommend using it always inside here directly and not referencing a cell because it doesn't work in some cases when you do it this way. But for now, I referenced the cell, I hit "comma." The next argument is simply a label - notice the quotes because it's text - to put a label in to show the user how to click on this. It says "click to open excel teaching template" so I am going to click on that and it opens up another excel workbook on my computer. And there it is.
Let's go to the next example - How to jump to a specific cell on an external worksheet. So here, here, we can do the same function, and this time the link is in here. Notice the brackets to make it easier for Excel to understand. This time I have included with single quotes the name of the worksheet and the external workbook as well as a exclamation point and then the exact cell that I want to jump to. So let's try that and see what happens. Click here and instead of opening and putting the cursor over here, it jumped directly to F10 because I told it to. That's pretty useful if I want to save someone the trouble.
Let's go here. You can also jump to a specific range on a worksheet within the existing workbook that you're currently working with. So that's exactly what I am going to do right here. So I am going to go and see what's going on. Instead of the location being C Drive // all my folders, it's just the name of the existing workbook that I am working on right now. Also the single quotes for the name of the worksheet, which is actually down here, the exclamation point and the range of cells with the colon in between, cause that's the way of showing a range. We also have the label as well. Once I click enter and I click on with the mouse, I get not only that worksheet but the range of cells as I instructed Excel to do.
Let's now go to a Word document. Not just an Excel document. And we are going to get the hyperlink location - the name of the Word document as well at the end of it. I can also, this part is optional, include a string of text to search for and jump to once that document opens.
If this is blank, it will just open the file normally. But since I put this in, I am going to search for the text "Transition to the slide." And let's see what happens. If I click on it, it will open up this Word document and there it is - "Transition to the Slide" is currently where the cursor started at.
We can do the same thing with a document that we grab from the Web. So let's do it the same way but this time instead of referencing a file on my computer, I'm referencing a website of Microsoft Word. Same exact thing and this time I am going to search for a string of the word "Notebook." Let's see what happens when I click on it - "Are you sure you want to open this file?" - "Yes, I am." And there it is. Right towards the text - "Notebook Test."
Let's go back one more time to the last bit which is just a straight up website. So if I type in a url for HowCast.com and I hit enter, it automatically turns it into a link that I can press and jump to the website directly.
One last thing to note is if you want more information about the hyperlink function, you can go to the function, insert function button. Type in the name of the function. Hit enter. Once it's highlighted, you hit "Help on this Function" which brings you to this article which has plenty of information about how this works, what the different arguments are and examples of it. There's lots of good stuff here. Check it out and that is the hyperlink function in Excel.