Inserting a Hyperlink in Excel 2007

Hyperlinks are links in a document that open another document, another workbook or move to another location in the current document by clicking on the link. Often, hyperlinks are used to open another Web page although the destination can also be an e-mail address or another program. The destination document or program can be on your local hard drive, network server, Web pages on the Internet or simply another worksheet in your workbook.

A hyperlink is represented by underlined blue text although you can add a hyperlink to graphical objects or clip art as well. In Excel, you may wish to create hyperlinks that jump you to another worksheet, another workbook or another file. For example, if you link to a PowerPoint file, PowerPoint will automatically open on the user’s machine and display the document when the user clicks the hyperlink.

If you link to a Web Page on the Internet, the user’s default Web browser will launch and display the Web page.

To Insert a Hyperlink to a File or Web Page:

1. Activate the cell containing the text or select the graphic where you want to insert a hyperlink.
2. Click the Insert tab on the Ribbon.
3. Click the Hyperlink button on the Links group
   Or
   Press the Ctrl + K keystroke combination.
   

   Hyperlink button

4. Click the Existing File or Web Page button.
5. To link to an existing file, navigate to the directory and then highlight the desired file.
6. To link to a Web page, type the Web address in the Address text box.
7. Click OK.

To Insert a Hyperlink to a Location in an Open Document

1. Activate the cell containing the text or select the graphic where you want to insert a hyperlink.
2. Click the Insert tab on the Ribbon.
3. Click the Hyperlink button on the Links group
   Or
   Press the Ctrl + K keystroke combination.
4. Click the Place in This Document button
5. Enter the cell reference in the Type the Cell Reference text box.
6. Choose the worksheet where the reference is located under the Or Select a Place in this Document area.
7. Click OK.

Tip: To delete a hyperlink, right-click the hyperlink and choose Remove Hyperlink to remove only the hyperlink or Clear Contents to remove the hyperlink and the text.

Similar Posts:

• Shortcut Keys in Excel
• Disable Automatic Creation of Hyperlinks in Excel 2007
• Inserting and Removing Page Breaks in Excel
• Inserting Headers and Footers in Excel 2007
• Using Cross-References in Word 2007
• Easily Move or Copy a Worksheet in Excel
• Absolute Cell References in Excel

Tagged as: Excel Tips, Microsoft Office Tips