Using Hyperlinks To Navigate

The Hyperlink feature added in Excel 97 can be used in three ways to save time when moving around documents.

Using Hyperlinks to move around within a workbook
You can use the Insert Hyperlink command to create a hyperlink in a cell that points to another cell or range of cells.  The cell or range the hyperlink points to can be on the same sheet or on any other sheet in the workbook.  This is a simple way to create a table of contents.  The cell or range can be named but does not have to be named.  Tip:  If you want your hyperlink to appear as a label then you should type the label you want into the cell before you make that cell a hyperlink.  Otherwise the cell will show the link information as the hyperlink.  This is an excellent way to create a table of contents to a large document. 

Hyperlinks that Point to Other Locations In a Workbook

 Using Hyperlinks to Open Related Files
You can also use the Insert Hyperlink command to create a hyperlink to another file.  This file can be another Excel workbook that you might frequently need to open when you have the current workbook opened or it might be an entirely different file format and does not even have to be a file created by a Microsoft product.  As long as the file extension is registered with Windows, then Windows will open the appropriate software and open the requested file.  This could be used, for example, to open a Word processing document or a database that is frequently modified at the same time you are working with a particular workbook.

 Using a Hyperlink to Open a Web Page
You can use the Insert Hyperlink command to create a hyperlink Web page.  This could be useful if there was information on the Internet that you needed to update a particular workbook.  For example, you can get up-to-date stock prices, interest rates, currency exchange rates, and commodity prices (ex. oil and gas prices) from Web pages.

- END -