You may already be familar with hyperlinking using the MicroSoft Office series of applications. The process in Excel is identical to the process in the other applications. In case you are not familiar, we will show the process here. You might want to try it out in the other applications as well!
Hyperlinking in Excel is very similar to hyperlinking on the word. There is a "target" word or phrase. When you click on the target word or phrase, you will be transported to a new place. The new place could be a different window in the same document or it could be to load a new Excel document. The document launched does not have to be an Excel document. You could have Excel launch a document created by another application. That is, you could open a Word document from Excel. You could open a webpage (if your computer is connected to the Internet). In fact, you could use Excel as a "table of contents" to all the documents on your Hard Drive!
The hyperlink process will create a "path" from where you are in Excel to the new place.
Caution--If you share the document with someone else, the hyperlink may not work unless they have a document with the same name at the exact same directory level on their computer as you have on your computer when you create the hyperlink.
With that word of caution, let's see how it works.
Linking Within the Same Document
Suppose you have several "projects" on a single large spreadsheet. When you first open the document you would like to instantly go to the start of the desired project.
In this example, you have started a "table of contents" for all the projects you have on this spreadsheet. Project 102 starts in Cell g3. You wish to create a hyperlink to Cell G3 from Cell B4 (start of project 102).
You first position the mouse in the cell where the Hyperlink is to begin--the cell containing the target text that will be clicked to start the hyperlink.
Then select Insert + Hyperlink from the Menu.
This will open the Hyperlink Wizard that lets you set the destination for the linking process.
In
this case, we want to link within the same document. We should click on
the Place in this Document on the left.
Note the Wizard displays the text in the cell we are using as a target. (Taken from cell B2)
In the Cell Reference we enter the Cell Address of where we want the hyperlink to jump.
If we are satisfied, we click on OK.
The resulting spreadsheet will display the result in the familiar underline as a link.
You might want to look back at the Hyperlink Wizard and study the other options for hyperlinking besides within the same document. Depending on what you want to do, the Wizard offers other options for you to consider.