Microsoft Office Tutorials and References
In Depth Information
Working with Multiple Worksheets
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.
7.
Click OK. The link is inserted into the
worksheet. When you click the link, the Web page
you linked to is displayed in a Web browser.
Figure 6-21
Create a new workbook to link to.
Tip
To create a link to a Web page quickly,
simply type the Web page address in a
cell and press Enter. For example, type
http://www.marketwatch.com. Excel
automatically changes the text into a
link.
Tip
To save the new workbook in a folder
other than the current one, click the
Change button, select the drive/folder in
which you want to save the workbook,
and click OK to return to the dialog box.
Linking to a New Workbook
To create a hyperlink to a new workbook, follow
these steps:
5. If you want to edit this new workbook
now, select Edit the New Document Now.
Otherwise, select Edit the New Document
Later.
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-21.
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.
3. Click the Create New Document button from
the Link To list.
7.
Click OK. If you indicated that you wanted to
edit the workbook now, it is opened in Excel
so you can enter data. Regardless, the link is
inserted into the worksheet. When you click
the link, this new workbook is displayed.
4. Type a name for the new workbook in the
Name of New Document text box.
 
Search JabSto ::




Custom Search