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.
2
1
Click the cell in which you want
the link to appear.
3
2
Click the Insert tab.
1
3
Click Hyperlink.
l The Insert Hyperlink dialog box
appears.
4
Click a Link To location.
This example uses Existing File or
Web Page.
5
6 7
4
5
Type the text you want to display
in the worksheet field.
6
Click here and select the folder in
which the file you want to link to
is located.
8
7
Click the file to which you want
to link.
8
Click OK.
196
 
Search JabSto ::




Custom Search