[DrJ]

I am trying to find a way to make a hyperlink in a cell that links to either another cell on the same tab or a cell on another tab WITHIN the same Excel file.

Any ideas?

EDIT: I want a word in one cell that is a hyperlink so that when a user clicks on it, it will JUMP to another cell or another tab in the same Excel file

Just to clarify

[Marriedguy]

Yes.. I just figured this one out here what you do.

Excel does have a bookmark feature but Word does.

Open word and type a word, select it. Then Insert, Bookmark , in the dialogue box with open name the bookmark whatever you want and then click add. So that word or item is now a bookmark.

Now create the hyperlink. Type the word(s) and then select it. Right click on it and then select hyperlink from the drop down. Then in the dialogue box click bookmark… select that bookmark you created and OK.

Now just copy and paste them in your cell and thank the geniuses at Microsoft for the great integration features.

[ScottGem]

Its not necessary to use Word. Basically all you need do, is right click on the cell where you want the hyperlink and select Hyperlink and then follow the instructions from there.

[DrJ]

Sa-weet! Thanks guys! Didn't think it was possible.

ScottGem... couldn't rep you but it will come back around!

Thanks again!

[stanleyz]

You can do this:

Example tab name: Sales
Syntax: =Sales!A1
This reference tab "Sales" cell A1.
Note tab name cannot not have spaces. Use "_" for space otherwise tab reference don't work.
This works for 2003 Excel.