Excel: Inserting a Hyperlink

A hyperlink is a way to jump to another location. We use hyperlinks all the time to jump from one web site to another, or from one page on a website to another page.

We can add hyperlinks in an Excel document which will jump to another location within the document, to another file, or to a website.

The first section below is for any hyperlink.
There are then three sections listing the steps for the different types of links.



Insert a Hyperlink

1. Highlight the text to use as a hypertext.

2. Click on the Insert Tab on the ribbon.

3. Click on Hypertext in the Links section.

The following window appears: 

4. The left menu identifies what type of hyperlink you want. Click on the type you want. The middle will change based on your choice.


If linking to an Existing File
You would want to link to another file if that file has information related to this document. A table or resource data.

5.  Click on the file, if visible in the middle section.
If the file is not visible in the folder open: Click on the folder where the file exists. Click on the file.

6.  Check the Text to display, at the top of the window, to verify it is correct or change to a better description.  
.

You may change what appears in this box.

Do not change the information in the Address box at the bottom. 

7.     Click on Ok.

If linking to another tab within the same document
If your spreadsheet contains a list of customers with their information. One column could be their website. Instead of just a list, each cell could by a hyperlink to that customer's website.

5.  Click on the Tab you want to link to in the middle column. 

6.     At the top of the window, type in the cell you want to link to. That cell will appear in the top left corner of the screen.

7.  Check the Text to display, at the top of the window, to verify it is correct or change to a better description.  

8.      Type the cell reference: Type the cell you want the hyperlink to go to. This cell address will appear in the top left hand corner of the screen.

9.      Or select a place in this document: Click on the worksheet [tab] you want to link to

10.      Click OK.

If linking to a web page

If your spreadsheet contains a list of customers with their information. One column could be their website. Instead of just a list, each cell could by a hyperlink to that customer’s website. 

5.      Type in the web address for the web page in the Address bar in the middle bottom of the window.

6.     Check the Text to display, at the top of the window, to verify it is correct or change to a better description.  

7.   Ignore the Look in: box

    8.  Click on OK.