Microsoft Office Tutorials and References
In Depth Information
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
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 You need the Hyperlink_start and LevelDescriptions_start workbooks located in
your Chapter13 practice file folder to complete this exercise. Open the Hyperlink_start
workbook and save it as Hyperlink , and then open the LevelDescriptions_start workbook
and save it as LevelDescriptions . Then follow the steps.
1. In the Hyperlink workbook, on the Revenue by Level worksheet, click cell B9 .
2. On the Insert tab, in the Links group, click the Hyperlink button.
The Insert Hyperlink dialog box opens.
3. If necessary, click the Existing File or Web Page button.