The advantage of hyperlinks is that you can quickly jump to different locations. These different locations
can be places on the existing sheet.
They can be another tab, another workbook, or a Web site. As a first step,
let's try to create a mini table of contents.
I'm currently on the hyperlink sheet and I want to create a table of contents that allows me to jump
to these three sheets here.
All I have to do is start by typing the name I want to have in the cell. And then I just have to right
mouse click and go to link.
I come to this dialog box. The first option here is existing file or web page. If I wanted to jump
to another file, I can find a file here.
I can search for it in my directory here. If I wanted to jump to a web address,
I just have to type the address here.
In this case we want to jump to a place in this document.
I can see the names of my tabs here and any defined names I have in that workbook.
If you're using a defined name for a range or a cell, you can quickly jump to that range by selecting
the defined name from here.
So for this style one, I want to jump to the style tab.
Default is to jump to A1. If I don't want A1, I want another cell, I can type it in here. And let's add
a screen tip as well.
Click on ok and ok.
Now the moment you hover over this you see that screen tip. When I click on it, it jumps to the style sheet
to cell A3 because I change the default from A1 to A3.
We can also add more information here.
Let's add a link to the second and the third tabs. This time for the second tab,
let's add it another way.
Let's go to the Insert tab, go to link here, and click on insert link.
I'm going to go with theme.
I'll keep it to A1 and I'm not going to add a screen tip.
Let's add the third one
and click on ok.
Let's also add more information about these. Now every time we click these,
we jump to that tab.
So how about creating a back button to our table of contents from each of these tabs.
And let's put that back link to cell F1.
Well first of all I have to make sure that cell F1 is empty on all these 3 tabs. And I've already checked
that, it's empty.
Next step, I'm going to highlight these three tabs, right mouse click and go to link. But I can't add a
link.
It's grayed out. You can't add hyperlinks at the same time to many sheets. You need to use a work around
for this if you want to do it at the same time. Because you could do it one at a time
but if you have a lot of tabs it's going to take a lot of time. So the way you need to do this is to
go to one of the tabs and create your link.
I'm going to call this "TOC" for table of contents, right mouse click, go to link and let's jump
back to hyperlinks to cell A3 and click on ok.
Now, these other tabs they don't have "TOC" but F1 has to be empty so let's just add some more
space here
and this one, F1 is empty as well.
This is what you need to do.
You need to go to the tab
you did the first hyperlink in and copy it. Control+C. Now highlight all the other tabs.
If it's pretty much every sheet on your workbook, you can right mouse click and select all sheets and
then deselect the ones you don't need by holding down the control key.
Then go to cell F1 where you want to have your hyperlink in and press control+V.
This automatically will put that back link to all your tabs.
Now when I click this, it jumps directly to my hyperlinks tab.
Okay so you can add hyperlinks to cells.
We saw that you can link to other files, you can link to a web page.
But now how about adding hyperlinks to an icon or to a shape?
In Excel you can add hyperlinks to any object in your workbook. So let's go with insert icon and select
an icon from this list.
Click on insert, adjust the icon the way you like.
And then all you have to do is right mouse click, select link and pick where you want to link this to.
So in this example I'll go place in this document and I'll go with sample report.
When I hover over this, it's clickable and it takes me directly to my sample report tab.
Now what about linking to a Web site?
Well, the moment you start typing in a web address directly in a cell and you press enter, Excel recognizes
that it's a link. You don't have to manually add the link. But if you wanted to have a friendly name
for this, you can go and edit this hyperlink.
Just right mouse click, edit hyperlink.
The address is taken from what was in the cell.
Now I'm just gonna change the text to say "Visit site" and then click on ok.
Now when you click this, your default browser is going to open and it's going to take you directly
to that Web site.
You can also insert a shape.
So let's go with this shape.
Just draw it out.
Adjust it as you like, add text to this and add a hyperlink. Just right mouse click, select link and type in
the web address directly in here and then click on ok.
Now this becomes a clickable button.
You can also add hyperlinks to create email addresses. So let's say we want the user to be able to click
this and get their email to open with the correct email address.
We just have to right mouse click, go to link, go to email address.
If you've used any recent email addresses, you can see it here. So you can select it directly from
this list.
Otherwise, you just have to type in the email address and you can add a subject line and then click on
OK.
So now every time we click this, our email opens with the email address and the subject line.
Okay so these are the different ways you can use hyperlinks in your files.