Microsoft Office Tutorials and References
In Depth Information
Working with Multiple Worksheets
Browse the Web
If you have used the file recently, click
the Recent Files button and select the file
from those listed.
5. To link to a specific place within a file such as
another Excel workbook or a Word document,
click the Bookmark button. To link to a cell
on a specific worksheet, select that
worksheet from the Cell Reference section of the
Or Select A Place In This Document box. If
you’ve created a range name or a bookmark
in a Word file, select it from the Defined
Names section in the Or Select A Place In
This Document box. Click OK to return to
the dialog box.
Create a link to a Web page.
3. Click the Existing File or Web Page button
from the Link To list.
4. Enter the path to the page you want to link
to in the Address text box, or click the
Browse the Web button, and use your Web
browser to display the page you want to link
to. After displaying the page, do not close
your browser, but simply switch back to Excel
and the dialog box—the Web page address
automatically appears in the Address box.
6. To enter a ScreenTip for the link, click the
ScreenTip button, type the description to
display in the ScreenTip, and click OK to return
to the dialog box.
Click OK. The link is inserted into the
worksheet. When you click the link, the file you
linked to is opened and displayed.
Linking to a Web Page
To create a hyperlink to a Web page out on the
Internet, or on your company’s network, follow
If you have visited the page recently, click
the Browsed Pages button and select the
page from those listed.
1. Click the cell containing the text you want to
use as the link, or click a graphic.
5. Some Web pages are designed with
bookmarks that link to places on that page. To
link to a specific place within the page, click
the Bookmark button, and select a place
from those listed. Click OK to return to the
2. Click the Hyperlink button on the Insert tab.
The Insert Hyperlink dialog box appears, as
shown in Figure 6-20.