4 Easy Ways to Add Links in Microsoft Excel

Download Article

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

Download Article

• Link to a Location in a Workbook
|
• Link to a Webpage
|
• Link to Another File or Folder
|
• Insert a Link to Send an Email
|
• Video
|
• Q&A
|
• Tips

|Show more|Show less

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 How.com.vn 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.

Steps

Method 1

Method 1 of 4:

Link to a Location in a Workbook

Download Article

1. 
   1
   Open a workbook in Microsoft Excel. If needed, you can begin a new Spreadsheet.

   • Microsoft Excel is available to download on Windows and Mac. You can also use the online web version at https://www.office.com.
2. 
   2
   Select the cell in which you want to create your link. You can create a shortcut link in any cell in your spreadsheet.
   Advertisement
3. 
   3
   Click Insert. This is the tab on the top toolbar, between Home and Page Layout.
4. 
   4
   Click Link. You can find this in the Links section of the Insert toolbar.

   • A new window will open.
5. 
   5
   Click Place in This Document. 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. 
   6
   Enter the cell location that you want to link to. 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. 
   7
   Change the displayed text (optional). 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.

   • 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.
Advertisement

Method 2

Method 2 of 4:

Link to a Webpage

Download Article

1. 
   1
   Copy the website you want to link to. 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. 
   2
   Select the cell in which you want to create your link. You can create a shortcut link in any cell in your spreadsheet.
3. 
   3
   Click Insert. This is the tab on the top toolbar, between Home and Page Layout.
4. 
   4
   Click Link. You can find this in the Links section of the Insert toolbar.
5. 
   5
   Select Existing File or Web Page. This will be the first option in the left panel.

   • If you're using Excel 2011, select Web Page.
6. 
   6
   Paste the website link into the "Address" field. 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. 
   7
   Change the text of the link (optional). 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. 
   8
   Click OK to create the link. Your link will appear in the cell you selected earlier.
Advertisement

Method 3

Method 3 of 4:

Link to Another File or Folder

Download Article

1. 
   1
   Select the cell in which you want to create your link. You can add a link to a document or location on your computer or server into any cell in your spreadsheet.
2. 
   2
   Click Insert. This is the tab on the top toolbar, between Home and Page Layout.
3. 
   3
   Click Link. You can find this in the Links section of the Insert toolbar.

   • A new window will open.
4. 
   4
   Select Existing file or webpage. 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. 
   5
   Select a folder or file to link to. 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. 
   6
   Type or paste an address for the file or folder (servers). 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. 
   7
   Change the text that is displayed (optional). 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. 
   8
   Click OK to create the link. 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.
Advertisement

Method 4

Method 4 of 4:

Insert a Link to Send an Email

Download Article

1. 
   1
   Select the cell in which you want to create your link. You can insert a mail link into any cell in your spreadsheet.
2. 
   2
   Click Insert. This is the tab on the top toolbar, between Home and Page Layout.
3. 
   3
   Click Link. You can find this in the Links section of the Insert toolbar.

   • A new window will open.
4. 
   4
   Select E-mail Address. This will be in the left menu panel, underneath Create New Document.
5. 
   5
   Enter the email address you want to link to. 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. 
   6
   Enter a premade subject into the "Subject" field (optional). 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. 
   7
   Change the link text that will be displayed (optional). By default, the link will display mailto:[email protected], 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. 
   8
   Click OK to insert your link. 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.
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.

  Thanks! We're glad this was helpful.
  Thank you for your feedback.
  If How.com.vn 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 How.com.vn

  YesNo

  Not Helpful 4Helpful 13
• 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.

  Thanks! We're glad this was helpful.
  Thank you for your feedback.
  If How.com.vn 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 How.com.vn

  YesNo

  Not Helpful 0Helpful 0

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Advertisement

Tips

• To edit a link after creating it, right-click the cell that contains the link, then click Edit Link.
  Thanks

  Helpful0Not Helpful0
• To delete a link from your sheet, right-click the cell, then click Clear contents.
  Thanks

  Helpful0Not Helpful0

Submit a Tip

All tip submissions are carefully reviewed before being published

Submit

Thanks for submitting a tip for review!

Advertisement

Video

You Might Also Like

Add Header Row in Excel: Freezing, Printing, Tables, Power Query

How to

Prepare Amortization Schedule in Excel

How to

Recover a Corrupt Excel File

How to

Unprotect an Excel Sheet

How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial

How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows

How to Merge Cells in Microsoft Excel: A Quick Guide

How to Create a Graph in Excel

How to

Create a Mortgage Calculator With Microsoft Excel

How to

Make a Spreadsheet in Excel

Easily Create a Drop-Down List in Microsoft Excel: Setup & Customization

How to

Insert Pictures in Excel That Automatically Size to Fit Cells

How to Unhide Multiple Rows in Microsoft Excel

How to

Link Sheets in Excel

Advertisement