Jezus the most simple things can be so hard

friso · Apr 3rd, 2002, 04:45 AM

Hello,

I just want to insert a hyperlink into my document that refers to antother worksheet.

I am using excel 97. I am able to make a nice hyperlink but when clicked upon it does not do the trick.

For example hyperlinks is in 'Sheet1'!A2
must link to 'Sheet2'!B3

however the link in A2 does not respond.
code used is:

=HYPERLINK('Sheet2'!B3;"Example")

any one knows the answer? I have browsed the forums but couldn't find a complete answer.

[ This Message was edited by: friso on 2002-04-03 03:48 ]

Dave Hawley · Apr 3rd, 2002, 04:58 AM

Hi Fisco

Type the word "example" in your cell then with the cell selected push Ctrl+K the rest should be easy.

friso · Apr 3rd, 2002, 05:07 AM

Thanks Dave,

It worked!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 3rd, 2002, 04:45 AM	#1
friso New Member Join Date: Apr 2002 Posts: 25	Hello, I just want to insert a hyperlink into my document that refers to antother worksheet. I am using excel 97. I am able to make a nice hyperlink but when clicked upon it does not do the trick. For example hyperlinks is in 'Sheet1'!A2 must link to 'Sheet2'!B3 however the link in A2 does not respond. code used is: =HYPERLINK('Sheet2'!B3;"Example") any one knows the answer? I have browsed the forums but couldn't find a complete answer. [ This Message was edited by: friso on 2002-04-03 03:48 ]

Apr 3rd, 2002, 04:58 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Fisco Type the word "example" in your cell then with the cell selected push Ctrl+K the rest should be easy.

Apr 3rd, 2002, 05:07 AM	#3
friso New Member Join Date: Apr 2002 Posts: 25	Thanks Dave, It worked!!