Home Application Office information

How to Insert Hyperlinks in Microsoft Excel

This wikiHow teaches you how to create a link to a file, folder, webpage, or new document in Microsoft Excel. You can do this on both the Windows and Mac versions of Excel. Open an Excel document. Double-click the Excel document in which...

Method 1 of 4:

Linking to a New File

  1. How to Insert Hyperlinks in Microsoft Excel Picture 1
    Open an Excel document. Double-click the Excel document in which you want to insert a hyperlink.
    1. You can also open a new document by double-clicking the Excel icon and then clicking Blank Workbook.
  2. How to Insert Hyperlinks in Microsoft Excel Picture 2
    Select a cell. This should be a cell into which you want to insert your hyperlink.
  3. How to Insert Hyperlinks in Microsoft Excel Picture 3
    Click Insert. This tab is in the green ribbon at the top of the Excel window. Clicking Insert opens a toolbar directly below the green ribbon.
    1. If you're on a Mac, don't confuse the Excel Insert tab with the Insert menu item that's in your Mac's menu bar.
  4. How to Insert Hyperlinks in Microsoft Excel Picture 4
    Click Hyperlink. It's toward the right side of the Insert toolbar in the "Links" section. Doing so opens a window.
  5. How to Insert Hyperlinks in Microsoft Excel Picture 5
    Click Create New Document. This tab is on the left side of the pop-up window.
  6. How to Insert Hyperlinks in Microsoft Excel Picture 6
    Enter the hyperlink's text. Type the text that you want to see displayed into the "Text to display" field.
    1. If you don't do this, your new document's name will be the hyperlink's text.
  7. How to Insert Hyperlinks in Microsoft Excel Picture 7
    Type in a name for the new document. Do so in the "Name of new document" field.
  8. How to Insert Hyperlinks in Microsoft Excel Picture 8
    Click OK. 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.
    1. 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.
Method 2 of 4:

Linking to an Existing File or Webpage

  1. How to Insert Hyperlinks in Microsoft Excel Picture 9
    Open an Excel document. Double-click the Excel document in which you want to insert a hyperlink.
    1. You can also open a new document by double-clicking the Excel icon and then clicking Blank Workbook.
  2. How to Insert Hyperlinks in Microsoft Excel Picture 10
    Select a cell. This should be a cell into which you want to insert your hyperlink.
  3. How to Insert Hyperlinks in Microsoft Excel Picture 11
    Click Insert. This tab is in the green ribbon at the top of the Excel window. Clicking Insert opens a toolbar directly below the green ribbon.
    1. If you're on a Mac, don't confuse the Excel Insert tab with the Insert menu item that's in your Mac's menu bar.
  4. How to Insert Hyperlinks in Microsoft Excel Picture 12
    Click Hyperlink. It's toward the right side of the Insert toolbar in the "Links" section. Doing so opens a window.
  5. How to Insert Hyperlinks in Microsoft Excel Picture 13
    Click the Existing File or Web Page. It's on the left side of the window.
  6. How to Insert Hyperlinks in Microsoft Excel Picture 14
    Enter the hyperlink's text. Type the text that you want to see displayed into the "Text to display" field.
    1. If you don't do this, your hyperlink's text will just be the folder path to the linked item.
  7. How to Insert Hyperlinks in Microsoft Excel Picture 15
    Select a destination. Click one of the following tabs:
    1. Current Folder - Search for files in your Documents or Desktop folder.
    2. Browsed Pages - Search through recently viewed webpages.
    3. Recent Files - Search through recently opened Excel files.
  8. How to Insert Hyperlinks in Microsoft Excel Picture 16
    Select a file or webpage. 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.
    1. You can also copy a URL from the Internet into the "Address" text box.
  9. How to Insert Hyperlinks in Microsoft Excel Picture 17
    Click OK. It's at the bottom of the page. Doing so creates your hyperlink in your specified cell.
    1. Note that if you ever move the item to which you linked, the hyperlink will no longer work.
Method 3 of 4:

Linking Within the Document

  1. How to Insert Hyperlinks in Microsoft Excel Picture 18
    Open an Excel document. Double-click the Excel document in which you want to insert a hyperlink.
    1. You can also open a new document by double-clicking the Excel icon and then clicking Blank Workbook.
  2. How to Insert Hyperlinks in Microsoft Excel Picture 19
    Select a cell. This should be a cell into which you want to insert your hyperlink.
  3. How to Insert Hyperlinks in Microsoft Excel Picture 20
    Click Insert. This tab is in the green ribbon at the top of the Excel window. Clicking Insert opens a toolbar directly below the green ribbon.
    1. If you're on a Mac, don't confuse the Excel Insert tab with the Insert menu item that's in your Mac's menu bar.
  4. How to Insert Hyperlinks in Microsoft Excel Picture 21
    Click Hyperlink. It's toward the right side of the Insert toolbar in the "Links" section. Doing so opens a window.
  5. How to Insert Hyperlinks in Microsoft Excel Picture 22
    Click the Place in This Document. It's on the left side of the window.
  6. How to Insert Hyperlinks in Microsoft Excel Picture 23
    Enter the hyperlink's text. Type the text that you want to see displayed into the "Text to display" field.
    1. If you don't do this, your hyperlink's text will just be the linked cell's name.
  7. How to Insert Hyperlinks in Microsoft Excel Picture 24
    Click OK. This will create your link in the selected cell. If you click the hyperlink, Excel will automatically highlight the linked cell.
Method 4 of 4:
  1. How to Insert Hyperlinks in Microsoft Excel Picture 25
    Open an Excel document. Double-click the Excel document in which you want to insert a hyperlink.
    1. You can also open a new document by double-clicking the Excel icon and then clicking Blank Workbook.
  2. How to Insert Hyperlinks in Microsoft Excel Picture 26
    Select a cell. This should be a cell into which you want to insert your hyperlink.
  3. How to Insert Hyperlinks in Microsoft Excel Picture 27
    Click Insert. This tab is in the green ribbon at the top of the Excel window. Clicking Insert opens a toolbar directly below the green ribbon.
    1. If you're on a Mac, don't confuse the Excel Insert tab with the Insert menu item that's in your Mac's menu bar.
  4. How to Insert Hyperlinks in Microsoft Excel Picture 28
    Click Hyperlink. It's toward the right side of the Insert toolbar in the "Links" section. Doing so opens a window.
  5. How to Insert Hyperlinks in Microsoft Excel Picture 29
    Click the E-mail Address. It's on the left side of the window.
  6. How to Insert Hyperlinks in Microsoft Excel Picture 30
    Enter the hyperlink's text. Type the text that you want to see displayed into the "Text to display" field.
    1. If you don't change the hyperlink's text, the email address will display as itself.
  7. How to Insert Hyperlinks in Microsoft Excel Picture 31
    Enter the email address. Type the email address that you want to hyperlink into the "E-mail address" field.
    1. You can also add a pre-determined subject to the "Subject" field, which will cause the hyperlinked email to open a new email message with the subject already filled in.
  8. How to Insert Hyperlinks in Microsoft Excel Picture 32
    Click OK. This button is at the bottom of the window.
4 ★ | 1 Vote
« PREV : How to Make a Bar...
How to Create a Drop... : NEXT »
Read More
Maybe you are interested