Excel 2010 Bible

Part IV: Using Advanced Excel Features

610

Working with Hyperlinks

A hyperlink is clickable text that provides a quick way to jump to other workbooks and files. You

can set up hyperlinks to display files on your own computer, your network, and the Web. For

example, you can create a series of hyperlinks to serve as a table of contents for a workbook. Or,

you can insert a hyperlink that displays a Web page in the default Web browser.

Inserting a hyperlink

You can create hyperlinks from cell text or graphic objects, such as shapes and pictures. To create

a text hyperlink in a cell, select the cell and choose Insert ➪ Links ➪ Hyperlink (or press Ctrl+K).

Excel responds with the Insert Hyperlink dialog box, as shown in Figure 28.4.

FIGURE 28.4

Use the Insert Hyperlink dialog box to add hyperlinks to your Excel worksheets.

Select an icon in the Link To column that represents the type of hyperlink you want to create. You

can create hyperlinks to a file on your hard drive, a Web page on the Internet, a new document, or

a location in your current workbook. In addition, you can create a hyperlink that consists of an

e-mail address. Then, specify the location of the file that you want to link to. The dialog box

changes, depending upon the icon selected. If you like, click the ScreenTip button to provide some

additional text that appears as a mouse-hover–activated ToolTip. Click OK, and Excel creates the

hyperlink in the active cell.

Figure 28.5 shows a worksheet with hyperlinks that function as a table of contents for a workbook.

Clicking a link activates a worksheet in the workbook. The example also shows an e-mail address

that when clicked, activates the default e-mail program.