Microsoft Office Tutorials and References
In Depth Information
CREATE A LINK
from an Excel workbook
You may be familiar with the many benefits of links as
a result of using the Internet. On the Internet, when
you click a link, you jump to a new Web page with
more links, creating an enormous and seamless web
of information. Like most Office applications, Excel
lets you create links. These links can take you to a
place in the same worksheet or workbook, to a
document created by another Office application, or
even to a Web page.
Linking a document is different from paste linking.
Instead of pulling data created by another application
into Excel, a link enables you to move from a
worksheet to a related document.
You can use links to jump directly to a chart or
PivotTable based on the worksheet. Or, you can link
a worksheet to a Word document providing detailed
information or identifying the assumptions used in
the worksheet. You can also create e-mail address
links. This option is useful if you are going to save
your file as a Web page and you want readers to be
able to click a link to e-mail you.
Click the cell in which you want
the link to appear.
Click the Insert tab.
l The Insert Hyperlink dialog box
Click a Link To location.
This example uses Existing File or
Type the text you want to display
in the worksheet field.
Click here and select the folder in
which the file you want to link to
Click the file to which you want