Adding a Hyperlink to a Worksheet

In Hour 19, "Integrating Excel with Other Office Applications," you learned how to create a hyperlink that links to other Office documents. In this hour , you'll add a hyperlink to a worksheet that links to Web pages on the Internet.

When you point to a hyperlink, Excel displays the document path (for example, http://www.samspublishing.com ) to which the link points. When you click a hyperlink, Excel moves to the location to which the link points. A hyperlink appears in blue (default color ) text in the worksheet.

Hyperlinks are useful when you want to browse through files on the Internet. The Web toolbar displays a list of the last 10 documents you jumped to by using the Web toolbar or a hyperlink. This feature makes it easy for you to return to these documents.

The Insert, Hyperlink option lets you create a hyperlink so that you can move to a Web page from a worksheet. In the next To Do exercise, you create a hyperlink to move from an Excel worksheet to a Web document. Once again, you should be using the Sales 1st Qtr workbook.

To Do: Create a Hyperlink to a Web Document

1. Click cell D16 on the Detail sheet. This cell will contain the hyperlink that brings you to the Web document.

2. Choose Insert, Hyperlink. Excel opens the Insert Hyperlink dialog box, as shown in Figure 24.3.

   Figure 24.3. The Insert Hyperlink dialog box.

   

   

   A quick way to create a hyperlink is to press Ctrl+K or click the Insert Hyperlink button on the Standard toolbar. Excel displays the Insert Hyperlink dialog box.

   
   

3. Click the Browsed Pages button on the Places bar to the left of the file list. A list of recently browsed Web pages appears.

   

   If you know the Web page's name, you can enter it in the Type the File or Web Page Name box. For example, http://www.samspublishing.com .

   
   

4. Click the URL to the page that you browsed to in the hyperlink list. Click OK. The Web page name is now a hyperlink and appears as underlined blue text in cell D16.

5. Point to the hyperlink. Notice how the mouse pointer becomes a hand. A ScreenTip containing the Web page address appears above the hyperlink (see Figure 24.4).

   Figure 24.4. The hyperlink and ScreenTip with the Web page address.

   

6. Click the hyperlink. Internet Explorer opens, and you see the Sams Publishing home page.

7. Click the Close ( x ) button in the upper-right corner of Internet Explorer. This step closes the Internet Explorer document and then returns you to the Excel worksheet. Notice the hyperlink text appears in purple, indicating that you have visited that site. Close the sales workbook.