Microsoft Office Tutorials and References
In Depth Information
Adding Hyperlinks to a Worksheet
Text entries in cells (known as hypertext, normally formatted as
underlined blue text)
Clip art and imported graphics from files you’ve inserted into the
worksheet (see Chapter 10)
Graphics you’ve created from the Shapes drop-down gallery on the
Insert tab (see also Chapter 10) — in effect, turning the graphic images
into buttons
When creating a text or graphic hyperlink, you can make a link to another
Excel workbook or other type of Office file, a website address (using the URL
address — you know, that monstrosity that begins with http://), a named
location in the same workbook, or even a person’s e-mail address. The named
location can be a cell reference or named cell range (see Chapter 6 for details
on naming cell ranges) in a particular worksheet.
To add the hyperlink to the text entry made in the current cell or a selected
graphic object (see Chapter 10) in your worksheet, follow these steps:
1. Click the Hyperlink button on the Insert tab of the Ribbon or press
Alt+NI, or simply press Ctrl+K.
Excel opens the Insert Hyperlink dialog box (similar to the one shown in
Figure 12-3) in which you indicate the file, the web address (URL), or the
named location in the workbook.
Figure 12-3:
Linking to a
web page
in the Insert
Hyperlink
dialog box.
2a. To have the hyperlink open another document, a web page on a
company’s intranet, or a website on the Internet, click the Existing File or
Web Page button if it isn’t already selected and then enter the file’s
directory path or web page’s URL in the Address text box.
If the document you want to link to is located on your hard drive or a
hard drive that is mapped on your computer, click the Look In drop-down
Search JabSto ::




Custom Search