PDF download Download Article
Quick ways to add links to websites, files, and other cells in a Microsoft Excel workbook
PDF download Download Article

Do you need to add a hyperlink in your Excel spreadsheet? You can easily create links to websites, other documents, or even other cells and sheets within the same spreadsheet. Adding a link to a cell can help users reference other sources and materials for additional information or support. This wikiHow will show you how to create and insert clickable links in your Microsoft Excel spreadsheet using your Windows or Mac computer.

Things You Should Know

  • To open the Link menu, select the cell where you want your link. Click "Insert" → "Link".
  • For "Place in This Document", enter the cell location you want to link to.
  • For "Existing File or Web Page", copy and paste a URL into the "Address" field.
Method 1
Method 1 of 4:

Link to a Location in a Workbook

PDF download Download Article
  1. If needed, you can begin a new Spreadsheet .
  2. You can create a shortcut link in any cell in your spreadsheet.
    Advertisement
  3. This is the tab on the top toolbar, between Home and Page Layout .
  4. You can find this in the Links section of the Insert toolbar.
    • A new window will open.
  5. This will be in the left menu panel, under Existing File or Web Page . You'll be able to add a link to any cell in your workbook.
    • If you want to link to a location in a different workbook, select Existing File or Web Page' , select the workbook, and then click Bookmark .
  6. Enter a cell location, or select from defined cells or ranges.
    • To type a cell location, select the sheet from under the Cell Reference header. Then, type the specific cell (ex: B35) into the Type the cell reference field.
    • If you want to add a link to a named range , select the name of the range from the Defined Names header. If you select one of these, you won't be able to type a location.
  7. By default, the link's text will be the cell that you are linking to. You can change this by typing anything you'd like into the Text to display field. [2]
    • You can click the "ScreenTip" button to change the text that appears when a user hovers their mouse cursor over the link.
    • Click OK to apply your finished link.
  8. Advertisement
Method 2
Method 2 of 4:

Link to a Webpage

PDF download Download Article
  1. To add a link to a webpage, you'll need to find the URL . This can be found in the address bar at the top of your web browser.
    • Highlight the entire URL, right-click the link, then select Copy or Copy address .
    • You can also use a keyboard shortcut.
      • On Windows, highlight the text and press CTRL + C to copy.
      • On Mac, highlight the text and press Command + C to copy.
  2. You can create a shortcut link in any cell in your spreadsheet.
  3. This is the tab on the top toolbar, between Home and Page Layout .
  4. You can find this in the Links section of the Insert toolbar.
  5. This will be the first option in the left panel.
    • If you're using Excel 2011, select Web Page .
  6. You can find this at the bottom of the window. Right-click the field, then click Paste .
    • You can also use a keyboard shortcut.
      • On Windows, click the field and press CTRL + V to paste.
      • On Mac, click the field and press Command + V to paste.
    • If you're using Excel 2011, paste the link into the "Link to" field at the top of the window.
  7. By default, the link will display the full address. You can change this to any text you'd like, such as "Company Website".
    • Enter your new text in the Text to display field.
      • If you're using Excel 2011, this is the "Display" field.
    • You can also click the "ScreenTip" button to change the text that appears when a user hovers their mouse cursor over the link.
  8. Your link will appear in the cell you selected earlier.
  9. Advertisement
Method 3
Method 3 of 4:

Link to Another File or Folder

PDF download Download Article
  1. You can add a link to a document or location on your computer or server into any cell in your spreadsheet.
  2. This is the tab on the top toolbar, between Home and Page Layout .
  3. You can find this in the Links section of the Insert toolbar.
    • A new window will open.
  4. This will be the first option in the left panel. This option allows you to add a link to any location or document on your computer (or server) in Excel.
    • In Excel 2011 for OS X, click "Document" and then click "Select" to browse for a file on your computer.
  5. The quickest way to link to a specific file or folder is to use the file browser to navigate to the one you want. You can link to a folder or a specific file.
    • Click the drop-down menu next to Look in to navigate through the folders on your computer.
  6. You can enter the address for the file or folder instead of navigating to it with the browser. This can be especially useful for entering locations on another server.
    • To find the actual address for a local file or folder, open your Explorer window and navigate to the folder. Click the folder path at the top of the Explorer window to reveal the address, which you can then copy and paste .
    • To link to a location on a server, paste the address for the folder or location that will be accessible to the reader.
  7. By default, the link will display the full address to the linked file or folder. You can change this by changing the text in the "Text to display" field.
  8. You'll see your link appear in the cell you had selected. Clicking it will open the file or folder that you specified.
    • Users of your spreadsheet will need to have access to the linked file from the same file location as used in your link. It may be more helpful to embed the file .
  9. Advertisement
Method 4
Method 4 of 4:

Insert a Link to Send an Email

PDF download Download Article
  1. You can insert a mail link into any cell in your spreadsheet.
  2. This is the tab on the top toolbar, between Home and Page Layout .
  3. You can find this in the Links section of the Insert toolbar.
    • A new window will open.
  4. This will be in the left menu panel, underneath Create New Document .
  5. Use the Email address field. You'll see the "Text to display" field fill as you add the address. mailto: will be added to the beginning of the address automatically.
    • If you've entered email addresses before, you can select them under the Recently used e-mail addresses header.
  6. You can leave the link as is if you'd like, but you can set a premade subject if you want to make things easier on your users.
  7. By default, the link will display mailto:address@example.com , but you can change this to whatever you'd like (ex: Contact Us).
    • Click the "Text to display" field and change the text.
    • Click the "ScreenTip" button to change the text that appears when the user hovers the mouse cursor over the link.
  8. Your new email link will be created, and clicking it will open your email client or website with a new message addressed to the address you entered.
  9. Advertisement

Community Q&A

Search
Add New Question
  • Question
    Can a link be inserted into a jpeg file?
    Community Answer
    Yes, but you wouldn't be able to open it.
  • Question
    How can I create a link that will add all weekly totals together so I have an annual total at the end of the year?
    Community Answer
    A macro would suit you better than a link. Use one to create a formula to add all the weeks.
Ask a Question
      Advertisement

      Tips

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

      Video

      About This Article

      Thanks to all authors for creating a page that has been read 650,401 times.

      Is this article up to date?

      Advertisement