 Today we're going to show you how to use hyperlinks in Excel 2016. Rod here and welcome to Bern to Learn. Do you know what a hyperlink does? Hyperlinks create a link to a file, a document, a URL, email or a new sheet. In Excel there are two ways to access the hyperlink process. The first way is to use a shortcut by pressing CTRL plus K. The second way is to click on insert and then click on link. This takes you to an insert hyperlink process where you'll find five different options to use and we will go over each one of them beginning with existing file. The existing file option creates a hyperlink to a web page or a file like a Word or Excel file. Here's how. First click on the option then find and select your document. The name of your document automatically appears in the text to display bar and will be the name of the hyperlink. You can leave the name as is or you can change it. We've decided to change the name to test1. Either way when the name is set, click OK and the hyperlink is created. Now we'll use the shortcut CTRL plus K to access the hyperlink process and show you how to use the web page option. Choose web page, then click in the address box and type in the address of the web page you will hyperlink to. For this example we'll use Burn to Learn's website address on YouTube. Next we'll change the name in the text to display box to Burn to Learn and then click OK. Pretty cool right? Don't forget to subscribe to our channel. Let's use the shortcut CTRL plus K again and show you how to use the place in this document option. This option will tell Excel where to place your hyperlink. Here's how. First select the option Place in this document and next go inside the Select a Place in this document box and choose example 1. Now go to the type cell reference box and type in the cell where you want the hyperlink to appear. Let's write cell C4 and then click OK and the hyperlink is created exactly where you want it. Now let's use the shortcut again and quickly show you how to use the Create a New Document option. Like the name says when you select this option you will create a new sheet. So first select the option. Next decide when to edit. If you choose edit the new document later your document will appear when the hyperlink is clicked. If you choose edit the new document now your document will appear immediately. We're choosing Edit the new document later and then type in Burn to Learn as the name of our document and then click OK. Let's write a title Hello World on our new document then save it and close it. So when we click on this link our Burn to Learn document will be opened. Using the shortcut again we're now going to show you how to use the last option email address. When you click this option your email manager opens in the recently used email addresses box. Now select the address you want. We're going to type in admin at burn to learn dot com in the email address. Now fill in the subject box. We're going to type in suggestions for the subject and we will write suggestions in the text to display box. Now click OK and check the link to make sure it works and it does. Now you know how to create hyperlinks using five different options in Excel 2016. Please take a few seconds to like this video, to comment and share it with friends. We love your feedback. Thanks for watching.