6 Types of Hyperlink You Can Create in Excel (Excel 2013)

Creating hyperlinks in Excel can be beneficial in terms of helping you to navigate better, i.e. jumping from one worksheet or cell to another, or opening an external file that is linked to a particular worksheet. Here are six types of hyperlink that you can easily create in Excel:

(1)  Link from a specific cell to another cell in the same worksheet (i.e. link within the same worksheet)

1.  Choose the specific cell that you want to link to another cell. For example, in Sheet1, you want to jump from cell B2 to H10.

link_types1

2.  Right-click cell B2 and select Hyperlink from the pop-up menu.

link_types2
 

3.  A new Insert Hyperlink dialog box appears. Click the Place in This Document button, then delete “A1” from Type the cell reference text box and replace with “H10”. Click the OK button.

link_types3
 

4.  Cell B2 turns into a hyperlink (i.e. underlined and in blue). Click the hyperlink and it will jump to cell H10.

link_types4
 

(2)  Link from one worksheet to another worksheet in the same spreadsheet file (i.e. link between two different worksheets in the same Excel file)

Let’s just say, you want to link cell A2 in Sheet1 to cell A2 in Sheet2 within the same spreadsheet file that you’re working on.

link_types5
 

1.  Right-click cell A2 (in Sheet1) and select Hyperlink from the pop-up menu.

link_types6
 

2.  A new Insert Hyperlink dialog box appears. Click the Place in This Document button, then delete “A1” from Type the cell reference text box and replace with “A2”. Select Sheet2 from the Cell Reference tree list and click the OK button.

link_types7
 

3.  Cell A2 (in Sheet1) turns into a hyperlink (i.e. underlined and in blue). Click the hyperlink and it will jump to cell A2 in Sheet2.

link_types8
 

 

(3)  Link to a separate file (i.e. link from one worksheet to another Excel file, Word document, etc.)

You can create a link in the current spreadsheet file that opens up another file when a reader clicks the link. For example, when a reader clicks the link in cell A2 in a spreadsheet file called Status Report, it will open a Word document called Project Charter.

link_types9
 

1.  Right-click cell A2 (in the Status Report file) and select Hyperlink from the pop-up menu.

link_types10
 

2.  A new Insert Hyperlink dialog box appears. Click the Existing File or Web Page button. Note that the Current Folder button is selected by default. Locate the file that you want to link it to, select that file and click the OK button.

link_types11
 

3.  Cell A2 turns into a hyperlink (i.e. underlined and in blue). Click the hyperlink and it will open the Project Charter file.

link_types12
 

(4)  Link to external website

You can also create a link in the spreadsheet file that directly opens up a web page. For example, when a reader clicks the link in cell B2, it will open a web browser that directs the reader to the home page of the web address, www.perrinator.com.

1.  Right-click cell B2 and select Hyperlink from the pop-up menu.

link_types13
 

2.  A new Insert Hyperlink dialog box appears. Click the Existing File or Web Page button. Key in the web address “http://www.perrinator.com” in the Address bar and click the OK button.

link_types14
 

3.  Cell B2 turns into a hyperlink (i.e. underlined and in blue). Click the hyperlink and it will open a web browser that displays the home page of http://www.perrinator.com.

link_types15
 

Note: Another way to quickly create a link to a website, is to type the web address into a cell and hit the Enter button.

link_types16
 

(5)  Link to email address

Creating a link to send an email is possible but this will launch Microsoft Outlook or Windows Live Mail as the default email application (it depends on the setting of your computer). For example, when a reader clicks the link in cell B2, it will launch Windows Live Mail with a blank email message that contains the recipient’s email address.

1.  Right-click cell B2 and select Hyperlink from the pop-up menu.

link_types17
 

2.  A new Insert Hyperlink dialog box appears. Click the E-mail Address button. Key in the recipient’s email address in the E-mail address text box and the subject of the email in the Subject text box. Click the OK button.

link_types18

Note: When you key in the recipient’s email address, you don’t have to type “mailto:” It will automatically appear as you type the email address.

3.  Cell B2 turns into a hyperlink (i.e. underlined and in blue). Click the hyperlink and it will launch Microsoft Outlook or Windows Live Mail (depending on your computer setting) that opens up a blank email message with the recipient’s email address and the email subject.

link_types19
 

(6)  Link to create a new file

This type of hyperlink is rarely used in Excel. It typically means that when someone clicks the hyperlink, it will open another new Excel file.

1.  Right-click cell B2 and select Hyperlink from the pop-up menu.

link_types20
 

2.  A new Insert Hyperlink dialog box appears. Click the Create New Document button. Enter the name of the new Excel file (e.g. “Learn Excel”) in the Name of new document text box.

link_types21
 

3.  The default location where the new file will be created and saved in your computer, is shown under the Full path section. You can change the default location to a different path by clicking the Change button, choosing the desired location and clicking the OK button.

link_types22
link_types23
 

4.  Under the When to edit section, there are two options to choose from, as explained below:

1.  Option 2 – Edit the new document now

You can open / edit the new Excel file later, i.e. after you click the OK button, you will return to the existing spreadsheet that you’re working on.

2.  Option 1 – Edit the new document later

You can open / edit the new Excel file straightaway, i.e. after you click the OK button, you will be immediately switched to the new spreadsheet.

link_types24
 

For the purpose of this tutorial, let’s go ahead with Edit the new document later, and click the OK button.

5.  You’re back at the existing spreadsheet where cell B2 turns into a hyperlink (i.e. underlined and in blue). Click the link and, depending on your computer setting, a Microsoft Excel Security Notice message will appear and prompt you to either proceed to open the link or cancel it. Click the Yes button.

link_types25
 

6.  And that’s it! You have successfully opened a new Excel file “Learn Excel”!

link_types26
 

Related Posts Plugin for WordPress, Blogger...
Sharing Is Caring!

Leave a Reply

Your email address will not be published. Required fields are marked *