Microsoft Office Tutorials and References
In Depth Information
Working with Multiple Worksheets
Linking to Elsewhere in the
Same or Different Workbook
A hyperlink (or simply, a link) is a bit of text or a
graphic that, when clicked, displays related
information elsewhere in the same worksheet, in
another worksheet, or within another workbook.
You can also link to other files such as Word
documents, audio or video files, or new
workbooks. In addition, you can link to a Web page
or an e-mail address.
In addition, when the mouse pointer moves over
a hyperlink, a ScreenTip appears, displaying the
location of the linked file, URL of the linked Web
page, or address of the e-mail link—as shown in
Figure 6-17. You can tell Excel to display different
information in the ScreenTip if you want, by
entering that information when you create the
Theme Colors Affect
If a hyperlink is text, it typically appears in
a blue, underlined font. When a text link is
used, it is often changed to purple,
underlined text so users can easy determine if a
link has been visited in the current working
session. However, if your worksheet uses a
different theme than the default (which is
Ofﬁce), the text color for your hyperlink
may be different, as the hyperlink color is
determined by the theme you select. For
example, in Figure 6-17, the worksheet
shown uses the Slipstream theme, so the
hyperlink appears in aqua, and changes to
blue when clicked. However, regardless of
the theme you apply to a worksheet, if you
apply a non-theme color to the hyperlink
text, it will not change color when clicked.
The mouse pointer changes when placed over
a hyperlink, and a ScreenTip appears.
Linking to the Same Workbook
To create a hyperlink to a place within the current
workbook, follow these steps:
1. Click the cell containing the text you want to
use as the link, or click a graphic.
2. Click the Hyperlink button on the Insert tab.
The Insert Hyperlink dialog box appears, as
shown in Figure 6-18.
When you move the mouse pointer over a
hyperlink, whether the link is a bit of text or a
graphic, the mouse pointer changes to a hand
to indicate that if you click, the linked file, Web
page, or e-mail address will be opened. (See
Figure 6-17.) This behavior makes it easier to
distinguish links from regular text and graphics.
3. Click the Place In This Document button
from the Link To list.