• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Lesson 21. Excel and the Internet > Adding Hyperlinks to a Worksheet

Adding Hyperlinks to a Worksheet

A hyperlink is a bit of text or a graphic that, when clicked, takes the user to a Web page, to a file on your hard disk, or to a file on a local network. To add a hyperlink to a worksheet, follow these steps:

  1. Select the cell(s) that contain the text you want to use for the link. For example, the cell might contain the text Click here to view supporting statistics. If you do not enter any text, Excel will insert the address of the file you select in step 4. If you want to use a graphic or a drawing as a link, select it instead.

  2. Click the Insert Hyperlink button on the Standard toolbar.

  3. If asked, make sure you save your workbook. The Insert Hyperlink dialog box appears, as shown in Figure 21.4.

    Figure 21.4. Insert a hyperlink in a workbook.

  4. Type the address of the Web page or file to which you want to link in the Link to File or URL text box, or click Browse to select it from a dialog box.

  5. If you want to jump to a particular location within your file, enter that location in the Named Location in File text box. If the destination file is an Excel file, you can enter a named range, a sheet, or cell address. In an HTML file, you can enter the name of an anchor.

  6. Click Use Relative Path for Hyperlink if you want Excel to use the destination file's relative address, rather than its actual address. A relative address can be easily changed if you think that the file to which the link refers will be moved.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint