In Excel 2003, you can insert hyperlinks directly into your worksheets. You might want to insert a link to another location in the same workbook, or to another Excel workbook located on the same computer. You might also want to insert a link to a Word document or to a webpage. No matter what type of hyperlink you want to create, the first step is to invoke the Edit Hyperlink dialogue box.

 

First, select the cell that will contain your hyperlink, and choose Insert->Hyperlink from the menu bar or click the hyperlink button on the standard toolbar to display the Insert Hyperlink dialogue box.

 

 

 

You can see four buttons running down the left side of the dialogue box under the Link to: heading. You can use these buttons to create a link to an Existing File or Web Page, a Place in This Document, Create New Document, or to an E-mail Address. You can enter the text for your Hyperlink in the Text to display field at the top of the dialogue box. This text will appear as a blue underlined hyperlink in the cell that you have selected.

 

You will see a drop list labeled Look in, just below the Text to display field. You can use this list to browse through the various folders on your computer to find the file that you want to create a link to. When you selection a folder or drive from the drop list, a list of available files or folders corresponding to the selection will appear in the large center area of the dialogue box.

 

You will also notice three buttons just to the left of the large center area. The buttons are labeled Current folder, Browsed Pages, and Recent Files. If you click Current folder, the files and subfolders of the current folder in the drop list will be displayed. If you click the Browsed pages button, a list of the URL’s for web pages you recently visited will be displayed.

If you click on the Recent Files button, you will see a list of recently accessed files. If you make a selection from any of these lists, the URL (or address) of the file will be entered into the Address field at the bottom of the dialogue box. You can also type a URL for a webpage or remote file, or the path to a local file directly into the Address field. In any case, the file or object referred to in the Address field will be the target of the hyperlink.

 

You can click the screen tip button in the upper right of the dialogue box, to add a brief comment that will appear when the mouse pointer hovers over the hyperlink.

You can use the Bookmark button to link to a specific location (like a cell range) in another Excel workbook. First, select the Excel file form the list, and then click the Bookmark button to specify the exact location within the selected workbook.

 

When you have finished making the necessary entries in the Insert Hyperlink dialogue box, you can click OK to create the hyperlink