Excel 2000 in a Nutshell

Name

Insert → Hyperlink

Synopsis

Excel allows you to create hyperlinks, links to other files, within your worksheet. The hyperlinks can be linked to text or an image. When you select Insert → Hyperlink, or Ctrl+K the Insert Hyperlink dialog displays as shown in Figure 6-25. The Insert Hyperlink dialog access the Most Recently Used (MRU) list for Windows. The MRU list keeps track of the files and web pages that you have recently viewed. You can create a link by selecting one of this files or web pages or you can type in a new link.

Figure 6-25. Insert Hyperlink Dialog

The Insert Hyperlink dialog allows you to create links to specific web sites, files on your machine, locations within the existing workbook, new workbooks, or email address, by selecting the appropriate icon in the Link To bar. The address used to specify the location of files you link to is based on the hyperlink base address specified on the Summary tab of File → Properties. If you want the link to exist for a specific line of text or graphic, make sure you select it prior to selecting the Insert → Hyperlink option. You need to select the text so that Excel knows where you want to place the link. Excel will create an HTML hyperlink on that text so that when someone clicks on the text the Microsoft link you select will open in your browser.