How to Insert Hyperlinks in Microsoft Excel: Files, Webpages, & More

PDF download Download Article
Step-by-step guide to creating hyperlinks in Excel
PDF download Download Article

This wikiHow teaches you how to create a link to a file, folder, webpage, new document, email, or external reference in Microsoft Excel. You can do this on both the Windows and Mac versions of Excel. Creating a hyperlink is easy using Excel’s built-in link tool. Alternatively, you can use the HYPERLINK function to quickly link to a location.

Adding Hyperlinks to an Excel Sheet

The easiest way to add hyperlinks is to use the HYPERLINK function , which allows you to add links without navigating menus. You can also add links by going to Insert > Link and choosing to link to a new document, existing document , web page, or email address .

Method 1
Method 1 of 6:

Using the HYPERLINK Function

PDF download Download Article
  1. If your Excel sheet isn't open, open it now.
  2. This function creates a hyperlink, but it also adds a "friendly name" that makes it easy to see what the link contents are. This function has two parameters: [1]
    • link_location is where you type in the path to the file and the file name.
    • friendly_name is the text shown for the hyperlink in your Excel spreadsheet. This parameter is optional.
    Advertisement
  3. To do this, add the link location in quotes between the parentheses. For example, to add a hyperlink to wikiHow's website, type =HYPERLINK("https://www.wikihow.com") .
    • Don't forget the quotes around the link location. If the quotes aren't present, you'll see an error when Excel tries to run the formula.
    • The types of locations you can link are as follows:
      • Web pages: https://www.wikihow.com
      • Email addresses: mailto:name@example.com
      • Specific cells in the sheet: #B10
        • Make sure to include the "#" before the cell or else the function won't work properly.
      • Sheets in the same workbook: #Sheet2!A1
        • Make sure to include the "#" before the sheet name or else the function won't work properly.
      • Folder locations: C:\Users\Admin\Documents\Example
      • Files: C:\Users\Admin\Documents\Example\example.docx
  4. 4
    Add the friendly name (optional). If you don't add a friendly name, the HYPERLINK function will just take whatever text you entered as the link location and hyperlink it. If you want to add a friendly name, add a comma after the link location and enter the friendly name in quotes.
    • For example, to add a hyperlink to wikiHow's website with the friendly name "wikiHow," you'd write =HYPERLINK("https://www.wikihow.com","wikiHow") .
    • Another example: if you wanted to add a link to a quarterly report saved as a Word document and give it the friendly name "Q1 Report," you'd write =HYPERLINK("C:\Users\Admin\Documents\Example\report.docx","Q1 Report") . The link location should be the file location of the report.
    • Don't forget the quotes around the friendly name. If the quotes aren't present, you'll see an error when Excel tries to run the formula.
  5. This will confirm the HYPERLINK formula and create the hyperlink in the selected cell. Clicking the link will open the specified file.
    6. Advertisement
Method 2
Method 2 of 6:

Linking to a New File

PDF download Download Article
  1. If your Excel sheet isn't open, open it now.
  2. This tab is in the green ribbon at the top of the Excel window. Clicking Insert opens a toolbar directly below the green ribbon. [2]
    • If you're on a Mac, note that there’s an Excel Insert tab and an Insert menu item in your Mac's menu bar. Select the Excel Insert tab.
  3. It's toward the right side of the Insert toolbar in the "Links" section. Doing so opens a pop up menu.
  4. It’s at the bottom of the Link pop up menu. This opens the Insert Hyperlink window.
  5. This tab is on the left side of the pop-up window, under “Link to:”. [3]
    • This option is not available on some versions of Excel. You’ll need to create the new document before making the hyperlink, then use the Existing File or Web Page option.
  6. Type the text that you want to see displayed into the "Text to display" field. This is the box above the “Name of new document” field.
  7. Do so in the "Name of new document" field.
  8. It's at the bottom of the window. By default, this will create and open a new spreadsheet document, then create a link to it in the cell that you selected in the other spreadsheet document.
    • You can also select the "Edit the new document later" option before clicking OK to create the spreadsheet and the link without opening the spreadsheet.
    • If something goes wrong with the hyperlink, see our guide for fixing a hyperlink in Excel .
    9. Advertisement
Method 3
Method 3 of 6:

Linking to an Existing File or Webpage

PDF download Download Article
  1. If your Excel sheet isn't open, open it now.
  2. This tab is in the green ribbon at the top of the Excel window. Clicking Insert opens a toolbar directly below the green ribbon. [4]
    • If you're on a Mac, note that there’s an Excel Insert tab and an Insert menu item in your Mac's menu bar. Select the Excel Insert tab.
  3. It's toward the right side of the Insert toolbar in the "Links" section. Doing so opens a pop up menu. [5]
  4. It’s at the bottom of the Link pop up menu. This opens the Insert Hyperlink window.
  5. It's on the left side of the window.
  6. Type the text that you want to see displayed into the "Text to display" field.
    • If you don't do this, your hyperlink's text will just be the folder path to the linked item.
  7. You can choose a file location on your computer, enter an address of a file or web page, or browse the internet. Here are the destination options:
    • Current Folder - Search for files in your Documents or Desktop folder.
    • Browsed Pages - Search through recently viewed web pages.
    • Recent Files - Search through recently opened Excel files.
    • Type in the location and name of a web page or file into the “Address” field. For example, this could be a URL to a website.
    • Click the Browse the Web button (a globe behind a magnifying glass). Go to the web page you’re linking to, then go back to Excel. Don’t close your browser!
  8. Click the file, folder, or web address to which you want to link. A path to the folder will appear in the "Address" text box at the bottom of the window.
  9. It's at the bottom of the page. Doing so creates your hyperlink in the specified cell.
    • Note that if you move the item to which you linked, the hyperlink will no longer work.
    10. Advertisement
Method 4
Method 4 of 6:

Linking Within the Document

PDF download Download Article
  1. If your Excel sheet isn't open, open it now.
    • This method links to a cell or sheet in your workbook. For example, if you’re tracking your bills in Excel , you can link to a summary sheet from your data sheet.
  2. This tab is in the green ribbon at the top of the Excel window. Clicking Insert opens a toolbar directly below the green ribbon.
    • If you're on a Mac, note that there’s an Excel Insert tab and an Insert menu item in your Mac's menu bar. Select the Excel Insert tab.
  3. It's toward the right side of the Insert toolbar in the "Links" section. Doing so opens a pop up menu.
  4. It’s at the bottom of the Link pop up menu. This opens the Insert Hyperlink window.
  5. It's on the left side of the window.
  6. You have two options for selecting a location:
    • Under “Type the cell reference,” type in the cell you want to link to.
    • Alternatively, under “Or select a place in this document,” click a sheet name or defined name.
  7. Type the text that you want to see displayed into the "Text to display" field.
    • If you don't do this, your hyperlink's text will just be the linked cell's name.
  8. This will create your link in the selected cell. If you click the hyperlink, Excel will automatically highlight the linked cell or take you to the sheet you selected.
    9. Advertisement
Method 5
Method 5 of 6:

Creating an Email Address Hyperlink

PDF download Download Article
  1. If your Excel sheet isn't open, open it now.
  2. This tab is in the green ribbon at the top of the Excel window. Clicking Insert opens a toolbar directly below the green ribbon.
    • If you're on a Mac, note that there’s an Excel Insert tab and an Insert menu item in your Mac's menu bar. Select the Excel Insert tab.
  3. It's toward the right side of the Insert toolbar in the "Links" section. Doing so opens a pop up menu.
  4. It’s at the bottom of the Link pop up menu. This opens the Insert Hyperlink window.
  5. It's on the left side of the window.
  6. Type the text that you want to see displayed into the "Text to display" field.
    • If you don't change the hyperlink's text, the email address will display as itself.
  7. Type the email address that you want to hyperlink into the "E-mail address" field.
    • You can also add a prewritten subject to the "Subject" field, which will cause the hyperlinked email to open a new email message with the subject already filled in.
  8. This button is at the bottom of the window.
    • Clicking this email link will automatically open an installed email program with a new email to the specified address.
    9. Advertisement
Method 6
Method 6 of 6:

Creating a Link to a Workbook on the Web

PDF download Download Article
  1. Double-click the Excel document in which you want to insert a hyperlink.
    • You can also open a new document by double-clicking the Excel icon and then clicking Blank Workbook .
  2. This can be referred to as the source workbook. This method creates an external reference link to a workbook on the Internet or your intranet.
  3. This will place a green box around the cell.
  4. You’ll need to copy the cell to reference it in your workbook. To copy it:
    • Go to the Home tab.
    • Click Copy in the “Clipboard” section. This button has an icon of two pieces of paper.
  5. This is the workbook that you want to place the external reference link in.
  6. You can place the link in any sheet of your workbook.
  7. This will open the Home toolbar.
  8. This is the button below the clipboard with a down arrow. This opens the Paste drop down menu.
  9. This is two chains linked together in front of a clipboard in the Paste drop down menu. The value of the external reference will appear in the cell you selected.
    • To see the external reference location, select the cell with the external reference. Then, check the Formula Bar for the location.
    10. Advertisement

Community Q&A

Search
Add New Question
  • Question
    How do I put a hyperlink in a text box?
    GaiusG
    Community Answer
    Right-click on the cell into which you wish to insert the link. Choose 'Link' on the menu which pops up, then insert the URL at the bottom of the little Link Setup Window.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 3 Helpful 4
  • Question
    My Excel chart hyperlinks work on my computer, but not on the computers of folks I send the chart to. Why?
    GaiusG
    Community Answer
    MS Office applications routinely disable links and other potentially harmful content whenever you open a file created on another PC or downloaded from the Internet. A warning message is displayed at the top of the document. The user then has the choice to trust the source of the document, which enables all content, or to view it in "Compatibility Mode," with potentially harmful content disabled.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 9 Helpful 0
  • Question
    The hyperlink option in the drop down menu is shaded and I can't click on it. What should I do?
    Community Answer
    Highlight the text you want to add a hyperlink to, then click hyperlink.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 24 Helpful 0
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      Warnings

      • If you move a file connected to an Excel spreadsheet by hyperlink to a new location, you will have to edit the hyperlink to include the new file location.
        Thanks
        Helpful 1 Not Helpful 1
      Advertisement

      You Might Also Like

      How to
      Make an Amortization Schedule in Excel: 2 Easy Ways
      How to
      Write a Simple Macro in Microsoft Excel
      How to
      Consolidate Data and Text in Microsoft Excel
      How to
      Delete Recent Documents in Microsoft Word or Excel
      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      The Best Ways to Make & Format Lists in Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Create a Chart in Microsoft Excel: Step-by-Step Guide
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Pie Chart in Microsoft Excel
      How to
      Use Macros in Excel
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/hyperlink-function-333c7ce6-c5ae-4164-9c47-7de9b76f577f
      2. ↑ https://support.microsoft.com/en-us/office/work-with-links-in-excel-7fc80d8d-68f9-482f-ab01-584c44d72b3e
      3. ↑ https://support.microsoft.com/en-us/office/insert-an-object-in-your-excel-spreadsheet-e73867b2-2988-4116-8d85-f5769ea435ba
      4. ↑ https://www.computerhope.com/issues/ch001831.htm#insert
      5. ↑ https://www.computerhope.com/issues/ch001831.htm#insert

      About This Article

      In other languages
      Thanks to all authors for creating a page that has been read 548,533 times.

      Is this article up to date?

      Advertisement