autolinks to sheets

M

mandy

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
 
L

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
 
D

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
 
Top