HYPERLINK function

[Guest]

Can someone help me understand this function's syntax?

Here's the situation: I have a workbook with a dozen tabs. I want to create
a thirteenth tab, called INDEX, which has hyperlinks to A1 of each tab.

If the first tab of my workbook is called Sheet1, I want the user to be able
to click on a link in the INDEX tab which takes him to cell A1 of Sheet1.

If I think of this in HTML terms, what I'm looking to do is something like
<a href="http://www.cnn.com/">Click here to go to CNN</a> where the
"friendly" name 'click here to go to CNN' is a live link that takes you to
CNN.com.

Possible? I think so.

I'm using XL 2000 if that matters.

Thanks for your help.

 

[Guest]

Assuming your file name as "Test"
and first sheet as "Sheet1", try this ... (paste it in INDEX Sheet)

=HYPERLINK("[Test]Sheet1!A1", "First Sheet")


*** Please do rate ***

 

[Guest]

Or you can just use the built in hyperlink feature:-

Select - Insert_Hyperlink

Highlight "Place in this Document"

Cell Reference "a1"

Sheet "Sheet1"

charlotte

Assuming your file name as "Test"
and first sheet as "Sheet1", try this ... (paste it in INDEX Sheet)

=HYPERLINK("[Test]Sheet1!A1", "First Sheet")


*** Please do rate ***

Can someone help me understand this function's syntax?

Here's the situation: I have a workbook with a dozen tabs. I want to create
a thirteenth tab, called INDEX, which has hyperlinks to A1 of each tab.

If the first tab of my workbook is called Sheet1, I want the user to be able
to click on a link in the INDEX tab which takes him to cell A1 of Sheet1.

If I think of this in HTML terms, what I'm looking to do is something like
<a href="http://www.cnn.com/">Click here to go to CNN</a> where the
"friendly" name 'click here to go to CNN' is a live link that takes you to
CNN.com.

Possible? I think so.

I'm using XL 2000 if that matters.

Thanks for your help.

 

[Dave Peterson]

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

And David also has a macro that builds this kind of table of contents page:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Another option if you want a more generic solution:
http://contextures.com/xlToolbar01.html
It's from Debra Dalgleish's site.

It builds a toolbar that you can use with any workbook to navigate to any
worksheet.

 

[Guest]

Good god that macro is amazing.

Thanks.

Dave

 

[Niek Otten]

I don't know about Excel2k, but here's how it goes in Excel 2003, hopefully the same in yours:

Insert>Hyperlink, click "Place in this document" and click the cell

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Can someone help me understand this function's syntax?
|
| Here's the situation: I have a workbook with a dozen tabs. I want to create
| a thirteenth tab, called INDEX, which has hyperlinks to A1 of each tab.
|
| If the first tab of my workbook is called Sheet1, I want the user to be able
| to click on a link in the INDEX tab which takes him to cell A1 of Sheet1.
|
| If I think of this in HTML terms, what I'm looking to do is something like
| <a href="http://www.cnn.com/">Click here to go to CNN</a> where the
| "friendly" name 'click here to go to CNN' is a live link that takes you to
| CNN.com.
|
| Possible? I think so.
|
| I'm using XL 2000 if that matters.
|
| Thanks for your help.
|
| --
| Brevity is the soul of wit.