You can also create these links within an Excel workbook to provide access to websites, other files, and to send e-mail messages to your colleagues. In this video, learn how to create and manage hyperlinks in Excel workbooks.
- [Instructor] One of the strengths of modern computers is your ability to connect to resources using hyperlinks. You probably think of the World Wide Web when you think of hyperlinks. But you can also create these links within an Excel workbook to provide access to websites, places within your current file, other files, or to send email messages. In this movie, I will show you how to create and manage hyperlinks in Excel workbooks. My sample file is the hyperlinks workbook and you can find it in the chapter eight folder of the exercise files collection.
I'll create three different types of hyperlinks or just links in this movie. Those will be to an external webpage, to a place within the current workbook, and to an email address. Let's say I want to create a link to the KinetEco company homepage. To do that, I click the cell where I want to create the link and then I can go to the Insert tab on the ribbon and then click Link. Doing so displays the Insert Hyperlink dialog box.
And I can either create one for an email address which is currently selected, place in this document, or web page or file. I'll go ahead and click Web Page or File. Here, I can provide a link to an existing file or web page. In this case, I happen to know it. So I'll type in http://www.kinetecoinc.com. That is a demo website. KinetEco isn't actually a real company. So that's there.
I will click OK. And you see that the link is now displayed in blue and underlined as unfollowed links are within Excel. If I move my mouse pointer over that link, you see that it changes to a pointing hand which means it can be clicked. So I'll click it once to follow. And you see that my Chrome web browser pops up and the homepage shows up as well. I'll go ahead and quit out of Chrome.
And go back into my workbook. Next, I can create a hyperlink that is a link to a place in the current workbook or to another workbook. So I will click in cell B5 and this time, instead of clicking the Link button which I could do, I'll press Command + K, which opens up the Insert Hyperlink dialog box as well. So you can either use the ribbon or the keyboard shortcut Command + K. I want to create a link to a place in this document, so I'll click the This Document header.
And I see references that I can use or I can go to a specific worksheet. In this case, I want to display the Category Sales worksheet so I'll click that. And then I'll just leave the cell reference to A1 on that worksheet. And click OK. I get the same hyperlink, but now when I click it, you see that it takes me directly to that worksheet. This is a simple situation, there are only two worksheets in this workbook, but I'm sure you can see how that would help within a large workbook with a lot of worksheets and also if you want to go to a specific cell.
Finally, you can create a link that will launch your email program to create an email message. So I'll go back to Dashboard, and I will click cell B7 which contains a made-up email address. I'll press Command + K again and I can type in my email address after I click the Email Address header. And there, I can type in the email address, so I'll type in email@example.com.
Press Tab to go to the subject, and I'll say that the subject is price inquiry. I have the subject for the price inquiry and the email address is correct again, it's not a real email address, just one I'll use here. Click OK. And I get the link. And I don't have Outlook or another email program installed on this computer but if I were to click it, my default email application would launch with an email message for that address and the subject that I typed in. If you want to edit a hyperlink, then hover your mouse pointer over top of the cell that contains the link and then hold down the Control key and click it.
You will get a shortcut menu and you can see here, about almost all the way to the bottom, at just about the bottom, you can click Edit Hyperlink. So click that, and you will go back to the Edit Hyperlink button. Now, click Cancel. You can also do the same thing to remove a hyperlink. So I will Control + click the link and then at the very bottom of the list, click Remove Hyperlink. And the address stays but the hyperlink goes away.
As you can see, hyperlinks let you create connections to resources outside your active workbook. You can also create links to places within your current workbook or to send an email message to yourself or to a colleague.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks