One of the characteristics of the Web is that documents
published on Web pages can have references, or hyperlinks, to locations
in the same document or to other Web documents. A hyperlink functions
much like a link between two cells or between two files, but hyperlinks
can reach any computer on the Web, not just those on a corporate
network. Hyperlinks that haven’t been clicked usually appear as
underlined blue text, and hyperlinks that have been followed appear as
underlined purple text, but those settings can be changed.
To create a hyperlink, click the cell in which you want to insert
the hyperlink and then, on the Insert tab, click Hyperlink. The Insert
Hyperlink dialog box opens.
Keyboard Shortcut
You can also open the Insert Hyperlink dialog box by pressing
Ctrl+K.
You can choose one of four types of targets, or
destinations, for your hyperlink: an existing file or Web page, a place
in the current document, a new document you create on the spot, or an
e-mail address. By default, the Insert Hyperlink dialog box displays the
tools to connect to an existing file or Web page.
To create a hyperlink to another file or Web page, you can use the
Look In navigation tool to locate the file. If you recently opened the
file or Web page to which you want to link, you can click either the
Browsed Pages or the Recent Files button to display the Web pages or
files in your History list.
If you want to create a hyperlink to another place in the current
Excel workbook, you can click the Place In This Document button to
display a list of available targets in the current workbook.
To select the worksheet to which you want to refer, you
click the worksheet name in the Or Select A Place In This Document box.
When you do, a reference with the name of the worksheet and cell A1 on
that worksheet appears in the Text To Display box.
If you want to refer to a cell other than A1 on the selected
worksheet, click the worksheet name in the Or Select A Place In This
Document box, and then change the cell reference in the Type The Cell
Reference box.
You can also create a hyperlink that generates an e-mail message
to an address of your choice. To create this type of hyperlink, which is
called a mailto
hyperlink, click the E-mail Address button.
In the dialog box that opens, you can type the recipient’s
e-mail address in the E-mail Address box and the subject line for
messages sent via this hyperlink in the Subject box.
Tip
If you use Windows Mail, Microsoft Outlook, or Microsoft Outlook
Express as your e-mail program, a list of recently used addresses will
appear in the Recently Used E-Mail Addresses box. You can insert any
of those addresses in the E-mail Address box by clicking the
address.
Clicking a mailto hyperlink causes the user’s default e-mail
program to open and create a new e-mail message. The e-mail message is
addressed to the address you entered in the E-mail Address box, and the
subject is set to the text you typed in the Subject box.
Regardless of the type of hyperlink you create, you can specify
the text you want to represent the hyperlink in your worksheet. You type
that text in the Text To Display box. When you click OK, the text you
type there appears in your worksheet, formatted as a hyperlink.
Tip
If you leave the Text To Display box empty, the actual link will
appear in your worksheet.
To edit an existing hyperlink, click the cell containing the
hyperlink and then, on the shortcut menu that appears, click Edit
Hyperlink. You can also click Open Hyperlink to go to the target
document or create a new e-mail message, or click Remove Hyperlink to
delete the hyperlink.
Tip
If you delete a hyperlink from a cell, the text from the Text To
Display box remains in the cell, but it no longer functions as a
hyperlink.
In this exercise, you’ll create a hyperlink to another document
and then a second hyperlink to a different location in the current
workbook.
Set Up
-
In the Hyperlink workbook, on the Revenue by Level worksheet, click cell
B9.
-
On the Insert tab, in the
Links
group, click the Hyperlink
button.
The Insert Hyperlink dialog box opens.
-
If necessary, click the Existing File
or Web Page button.
-
If necessary, use the controls to the right of the
Look in box to navigate to the
Chapter13 practice file
folder.
The files in the target folder appear in the Insert Hyperlink
dialog box.
-
In the file list, click the LevelDescriptions workbook, and then click
OK.
The workbook’s full path appears in the Text To Display box
and the Address box.
-
In the Text to display box,
edit the value so that it reads LevelDescriptions.
-
Click OK.
-
Click the hyperlink in cell B9.
The LevelDescriptions workbook appears.
-
In the LevelDescriptions
workbook, click the File tab, and
then click Close.
The LevelDescriptions workbook closes.
-
Right-click cell B11, and
then click Hyperlink.
The Insert Hyperlink dialog box opens.
-
In the Link to pane, click
Place in This Document.
The document elements to which you can link appear in the
dialog box.
-
In the Or select a place in
this document pane, click Notes.
-
Click OK.
The Insert Hyperlink dialog box closes, and Excel creates a
hyperlink in cell B11.
-
Right-click cell B11, and
then click Edit Hyperlink.
The Edit Hyperlink dialog box opens.
-
Edit the Text to display
box’s value so it reads Revenue
Notes.
-
Click OK.
The Edit Hyperlink dialog box closes, and the text in cell B11
changes to Revenue Notes.
-
On the Quick Access Toolbar, click the Save button to save your work.
Clean Up
Close the Hyperlink and LevelDescriptions workbooks.
