Microsoft Excel Functions & Formulas

Use the HYPERLINK function to link to

the Internet

This final tip in Chapter 9 shows how the HYPERLINK function is

normally used to create links to the Internet. You can jump directly

from your Excel application to predefined web sites using the

HYPERLINK function.

4

To link to the Internet:

1. In column A type the URLs of the web sites to which you

want to link.

2. In column B type the caption of the hyperlinks.

3. Select cells C2:C5 and type the following formula:

=HYPERLINK("http://" & A2,"Click to"&B2).

4. Press <Ctrl+Enter>.

Lookup and Reference Functions 239

9

Figure 9-22