autolinks to sheets

[Guest]

Hello there,

I have rcvd a spreedsheet with a summary sheet & various other sheets. Basically on the summary sheet you have a ref section which when you click on a particular ref automatically takes you to the ref sheet - is this called a hyperlink - how does it work?

thanks
mandy

 

[Lady Layla]

Open Excel, Go to Help, Type in Hyperlinks -- read away


: Hello there,
:
: I have rcvd a spreedsheet with a summary sheet & various other sheets.
Basically on the summary sheet you have a ref section which when you click on a
particular ref automatically takes you to the ref sheet - is this called a
hyperlink - how does it work?
:
: thanks
: mandy

 

[Frank Kabel]

Hi
goto 'Insert - Hyperlink' for this

 

[Dave Peterson]

Along with Frank's suggestion of Insert|Hyperlink, there's a worksheet formula
you can use:

Take a look at: =hyperlink() in excel's help.

I find the worksheet function easier to update and easier to work with.

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)

David also has a "build table of contents" macro at:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm