Excel 2010 Bible

Chapter 28: Excel and the Internet

611

The appearance of hyperlinks in cells is controlled by two styles in the Style Gallery. The Hyperlink

style controls the appearance of hyperlinks that haven’t been clicked, and the Followed Hyperlink style

controls the appearance of “visited” hyperlinks. To change the appearance of your hyperlinks,

modify either or both of those styles. See Chapter 6 for information about using and modifying

document styles.

To add a hyperlink to a Shape, select the Shape and then choose Insert ➪ Links ➪ Hyperlink (or,

press Ctrl+K). Specify the required information in the Insert Hyperlink dialog box, as outlined ear-

lier in this section. (Read more about Shapes in Chapter 22.)

FIGURE 28.5

Hyperlinks in a workbook.

Using hyperlinks

When you hover your mouse pointer over a cell that contains a hyperlink, the mouse pointer turns

into a hand. Click the hyperlink, and you’re taken to the hyperlinked document.

Tip
To select a cell that has a hyperlink with your mouse (without following the hyperlink), position your mouse
over the cell, click, and hold for a second or two before you release the mouse button. Or just activate a
nearby cell and use the navigation keys to select the cell that contains the hyperlink. n

When you hover your pointer over a Shape that contains a hyperlink, the mouse pointer turns into

a hand. To follow a hyperlink from a Shape, just point to the Shape and click.

If the hyperlink contains an e-mail address, your default e-mail program launches so that you can

send an e-mail to the address specified when you created the hyperlink.