Create or remove a hyperlink

For quick access to related information in another file or on a Web page, you can insert a hyperlink in a worksheet cell. You can also insert hyperlinks in specific chart elements.What do you want to do?

Create a hyperlink to a new file

Create a hyperlink to an existing file or Web page

Create a hyperlink to a specific location in a workbook

Create a custom hyperlink by using the HYPERLINK function

Create a hyperlink to an e-mail address

Delete a hyperlink

Create a hyperlink to a new file

1. On a worksheet, click the cell where you want to create a hyperlink.

   Tip You can also select an object, such as a picture or an element in a chart that you want to use to represent the hyperlink.

2. On the Insert tab, in the Links group, click Hyperlink.

   

   Tip You can also right-click the cell or graphic and then click Hyperlink on the shortcut menu, or you can press CTRL+K.

3. Under Link to, click Create New Document.
4. In the Name of new document box, type a name for the new file.

   Tip To specify a location other than the one shown under Full path, you can type the new location before the name in the Name of new document box, or you can click Change to select the location that you want and then click OK.

5. Under When to edit, click Edit the new document later or Edit the new document now to specify when you want to open the new file for editing.
6. In the Text to display box, type the text that you that you want to use to represent the hyperlink.
7. To display helpful information when you rest the pointer on the hyperlink, click ScreenTip, type the text that you want in the ScreenTip text box, and then click OK.

Create a hyperlink to an existing file or Web page

1. On a worksheet, click the cell where you want to create a hyperlink.

   Tip You can also select an object, such as a picture or an element in a chart that you want to use to represent the hyperlink.

2. On the Insert tab, in the Links group, click Hyperlink.

   

   Tip You can also right-click the cell or object and then click Hyperlink on the shortcut menu, or you can press CTRL+K.

3. Under Link to, click Existing File or Web Page.
4. Do one of the following:
   • To select a file, click Current Folder, and then click the file that you want to link to.

     Tip You can change the current folder by selecting a different folder in the Look in list.

   • To select a Web page, click Browsed Pages and then click the Web page that you want to link to.
   • To select a file that you recently used, click Recent Files and then click the file that you want to link to.
   • To enter the name and location of a known file or Web page that you want to link to, type that information in the Address box.
   • To locate a Web page, click Browse the Web , open the Web page that you want to link to, and then switch back to Microsoft Office Excel without closing your browser.
5. If you want to create a hyperlink to a specific location in the file or on the Web page, click Bookmark, and then double-click the bookmark that you want.

   Note The file or Web page that you are linking to must have a bookmark.

6. In the Text to display box, type the text that you want to use to represent the hyperlink.
7. To display helpful information when you rest the pointer on the hyperlink, click ScreenTip, type the text that you want in the ScreenTip text box, and then click OK.

Create a hyperlink to a specific location in a workbook

To link to a location in the current workbook or another workbook, you can either define a name for the destination cells or use a cell reference.

1. To use a name, you must name the destination cells in the destination workbook.

   How to name a cell or a range of cells

   1. Select the cell, range of cells, or nonadjacent selections that you want to name.
   2. Click the Name box at the left end of the formula bar .

      

      Name box

   3. In the Name box, type the name for the cells, and then press ENTER.

      Note Names cannot contain spaces and must begin with a letter.

2. On a worksheet of the source workbook, click the cell where you want to create a hyperlink.

   Tip You can also select an object, such as a picture or an element in a chart that you want to use to represent the hyperlink.

3. On the Insert tab, in the Links group, click Hyperlink.

   

   Tip You can also right-click the cell or object and then click Hyperlink on the shortcut menu, or you can press CTRL+K.

4. Under Link to, do one of the following:

   • To link to a location in your current workbook, click Place in This Document.

   • To link to a location in another workbook, click Existing File or Web Page, locate and select the workbook that you want to link to, and then click Bookmark.

5. Do one of the following:
   • In the Or select a place in this document box, under Cell Reference, click the sheet that you want to link to, type the cell reference in the Type in the cell reference box, and then click OK.
   • In the list under Defined Names, click the name that represents the cells that you want to link to, and then click OK.
6. In the Text to display box, type the text that you want to use to represent the hyperlink.
7. To display helpful information when you rest the pointer on the hyperlink, click ScreenTip, type the text that you want in the ScreenTip text box, and then click OK.

Create a custom hyperlink by using the HYPERLINK function

You can use the HYPERLINK function to create a hyperlink that opens a document that is stored on a network server, an intranet , or the Internet. When you click the cell that contains the HYPERLINK function, Excel opens the file that is stored at the location of the link.

For more information about using the HYPERLINK function, see HYPERLINK.

Create a hyperlink to an e-mail address

When you click a hyperlink to an e-mail address, your e-mail program automatically starts and creates an e-mail message with the correct address in the To box, provided that you have an e-mail program installed.

1. On a worksheet, click the cell where you want to create a hyperlink.

   Tip You can also select an object, such as a picture or an element in a chart that you want to use to represent the hyperlink.

2. On the Insert tab, in the Links group, click Hyperlink.

   

   Tip You can also right-click the cell or object and then click Hyperlink on the shortcut menu, or you can press CTRL+K.

3. Under Link to, click E-mail address.
4. In the E-mail address box, type the e-mail address that you want.
5. In the Subject box, type the subject of the e-mail message.

   Note Some Web browsers and e-mail programs may not recognize the subject line.

6. In the Text to display box, type the text that you want to use to represent the hyperlink.
7. To display helpful information when you rest the pointer on the hyperlink, click ScreenTip, type the text that you want in the ScreenTip text box, and then click OK.

   Tip You can also create a hyperlink to an e-mail address in a cell by typing the address directly in the cell. For example, a hyperlink is created automatically when you type an e-mail address such as someone@example.com.

Delete a hyperlink

To delete a hyperlink, do one of the following:

• To delete a hyperlink and the text that represents it, right-click the cell that contains the hyperlink, and then click Clear Contents on the shortcut menu.
• To delete a hyperlink and the graphic that represents it, hold down CTRL and click the graphic, and then press DELETE.
• To turn off a single hyperlink, right-click the hyperlink, and then click Remove Hyperlink on the shortcut menu.
• To turn off several hyperlinks at once, do the following:
  1. In a blank cell, type the number 1.
  2. Right-click the cell, and then click Copy on the shortcut menu.
  3. Hold down CTRL and select each hyperlink that you want to turn off.

     Tip To select a cell that has a hyperlink in it without going to the hyperlink destination, click the cell and hold the mouse button until the pointer becomes a cross , and then release the mouse button.

  4. On the Home tab, in the Clipboard group, click the arrow below Paste, and then click Paste Special.

     

  5. Under Operation, click Multiply, and then click OK.

See also:

• Change a hyperlink
• Copy or move a hyperlink
• Select a hyperlink without activating the link