Page 291 - Excel Workbook for Dummies

30_798452 ch21.qxp 3/13/06 8:40 PM Page 274
274 Part VI: Excel and the Web
The destinations you can specify for hyperlinks that take you outside of the current
workbook include

Filename for an existing file that you want to open when you click the hyperlink —
this file can be another workbook file or any other type of document that your
computer can open.
URL address of a Web page that you want to visit when you click the hyperlink —
this page can be on your company’s intranet or the World Wide Web and is
opened in your Web browser.
New document that you want to create in Excel or some other program on your
computer when you click the hyperlink — you must specify the filename and file
extension (which indicates what type of document to create and what program
to launch).
E-mail address for a new message that you want to create in your e-mail program
when you click the hyperlink — you must specify the recipient’s e-mail address
and the subject of the new message when creating the link.

Adding links to other sheets in a workbook

Perhaps the most common type of Excel hyperlink is the one that takes you from one
sheet to another within the same workbook. You can use these links to move quickly
between different tables and lists on the same or different worksheets without having
to resort to the sheet tabs or tab scroll buttons.

Try It

Exercise 21-1: Adding Hyperlinks to Other Sheets in a Workbook
If Excel is not currently running, launch the program. Open the workbook Exercise21-1.xls
in your Chapter 21 folder in the My Practice Spreadsheets folder on your hard disk
or in the Excel Workbook folder on the workbook CD-ROM. This workbook contains a
12-Month worksheet with small monthly calendars for all 12 months of 2006. You will
practice creating hyperlinks that take you to other sheets in the same workbook by
adding links to each of the small monthly calendars on the 12-Month worksheet.
Clicking these hyperlinks take you to the worksheet containing a larger version of the
calendar for the comparable month:

1. Position the cell cursor in merged cell B2 with the January 2006 heading and
then press Ctrl+K (for hyperlinK) or choose the Insert➪Hyperlink menu com-
mand to open the Insert Hyperlink dialog box.
2. Click the Place in This Document button in the pane on the left under the head-
ing Link To, and then click ‘Jan-06’ in the Or Select a Place in This Document list
box before you select OK.
As soon as you select OK, Excel closes the Insert Hyperlink dialog box. The text
January 2006 in the merged B2 cell now appears underlined and in blue color,
indicating that the text is now hypertext containing a link.
3. Position the mouse pointer somewhere over the January 2006 hypertext in the
merged cell B2 until the mouse pointer becomes a hand with the index finger as
its pointer.
When the mouse pointer assumes the hand-with-pointing-finger form, a ScreenTip
also appears underneath the pointer. The text in this tip indicates not only the