basic hyperlink function

How do I use the hyperlink function so the hyperlink goes to another page in the same excel document?

For example, I want the hyperlink in sheet one to take me to sheet 2. How do I do this using the hyperlink function?

Hello bobflu,

To Create a Hyperlink within the Workbook

1. Right Click the cell you want the hyperlink in.
2. At the bottom of the pop up menu click Hyperlink...
3. On the left side of the Hyperlink Dialog you will see a column labeld Link to:
4. Click on Place in this Document
5. To the right, type the cell address to hyperlink to in the box labeled Type the cell reference:
6. In the list box below, select the Sheet
7. Click OK

Sincerely,
Leith Ross

Hey,
is there any way of doing this using the hyperlink function? because i want the hyperlink change as data in a drop down list changes.
Example: Cell contains 1,2,3,4 and 5 in a drop down list. If cell one is selected the hyperlink will be different from 2,3,4 and 5. All different data has their own unique hyperlink.

I was thinking of using the IF function along with the HYPERLINK function to get this done.

Thanks.

But its not exactly what im looking for. I should have said earlier.

Is there any way of having each item in the drop down list as text, link to a different page on the spreadsheet?

Thanks a lot, I got it