How to Create a Hyperlink in Excel

Hyperlinks in Excel are commonly used to link to files, web pages, or specific areas in the existing document. They are a powerful navigation tool for users.

We will be looking at three frequently used hyperlinking methods in Excel. I have created a table to highlight their different functions.

For this guide, I will use the Office 365 version of Excel (build 2203). However, the instructions are similar in other versions.

Linking to a webpage

  1. Select the cell that you wish to link. In this case, we have selected the cell at D4.

    Select a cell
    Select the cell that you wish to link.
  2. After you have selected a cell, open the Insert tab from the top menu.

    Select Insert tab
    Select the Insert tab from the top menu.
  3. Navigate to the Link section and select the link icon to open the Hyperlink menu.
    Navigate to the link section
    Select the link icon from the link section.

    After selecting the link icon, the Insert Hyperlink menu will open.

    Insert Hyperlink Menu
    Insert Hyperlink menu opens.
  4. Since we want the cell to link to a webpage, we will enter the destination link in the Address box and select OK.
    Enter the destination link
    Enter the destination link in the Address box.

    The selected cell is now linking to the added webpage.

    Cell is linked
    The selected cell is now linked.

Linking to an existing file

  1. Select the cell you wish to link and open the Insert Hyperlink menu.

    Linking Existing File
    Open the Insert Hyperlink menu after selecting the appropriate cell.
  2. To select the file you want to link, click the Browse for file icon.

    Select Browse for File.
    Click on the Browse for file icon.
  3. Once the appropriate file has been located, select it and click OK to link.

    Select the File
    Select the appropriate file.
  4. The existing file is linked to the selected cell.
    File is linked.
    The existing file is linked to the cell.

    Clicking on the cell opens the file that we have linked to it.

    Linked File.
    The file is now linked.

Linking to the same document

  1. Select the cell and open the Insert Hyperlink menu. From the Link to section, select the second option: Place in This Document.

    Select Place in Document option.
    Select the Place in This Document option.
  2. In the Cell Reference section, the sheets of the documents are listed. From here, you can select the appropriate sheet to link.
    Select the Appropriate Sheet.
    Select the appropriate sheet.

    Excel allows you to link to a specific cell in the new sheet. To link to a cell, enter the cell reference in the box and click OK.

    Enter the cell address.
    Enter the cell address in the box.
  3. The sheet is now linked. Clicking on the link opens the new sheet and automatically selects the cell that was referenced.

    Referenced cell opens.
    Excel will automatically select the referenced cell.

Was this article helpful?

Leave a Comment