Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jyoung4992
 
Posts: n/a
Default How to link a document to a workbook with a hyperlink in excel

I have a tracker form in excel that I would like to have a hyperlink in a
cell that leads to a separate excel sheet. I had someone else help me but he
was only able to link to a word doc. I know this can be done, I just don't
know how. Someone said it was just a fomula I type. Where do I find this
formula? Help...anyone...Please.
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi

to hyperlink to an another excel sheet in the same workbook, choose insert /
hyperlink, click on places in this document, click on the sheet you want to
hyperlink to, click Ok.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Jyoung4992" wrote in message
...
I have a tracker form in excel that I would like to have a hyperlink in a
cell that leads to a separate excel sheet. I had someone else help me but
he
was only able to link to a word doc. I know this can be done, I just don't
know how. Someone said it was just a fomula I type. Where do I find this
formula? Help...anyone...Please.



  #3   Report Post  
JulieD
 
Posts: n/a
Default

alternatively, if you want to link to another workbook ... chose insert
/hyperlink / click on existing file or web page .. find the workbook on your
computer and click OK.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"JulieD" wrote in message
...
Hi

to hyperlink to an another excel sheet in the same workbook, choose insert
/ hyperlink, click on places in this document, click on the sheet you want
to hyperlink to, click Ok.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"Jyoung4992" wrote in message
...
I have a tracker form in excel that I would like to have a hyperlink in a
cell that leads to a separate excel sheet. I had someone else help me but
he
was only able to link to a word doc. I know this can be done, I just
don't
know how. Someone said it was just a fomula I type. Where do I find this
formula? Help...anyone...Please.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert existing Excel into Data source document to link to exist. KayLMPD Excel Discussion (Misc queries) 1 March 29th 05 12:37 PM
Link to password protected workbook dunnotar02 Excel Discussion (Misc queries) 1 March 22nd 05 06:44 PM
How to embed Word document into Excel and retain sizing, formatti. Kent Excel Discussion (Misc queries) 0 February 2nd 05 07:37 PM
link Access workbook to Excel workbook Toinett Excel Discussion (Misc queries) 1 January 31st 05 03:37 PM
Is it possible to link an Excel spreadsheet to a Word document an. Infinity Excel Discussion (Misc queries) 1 December 14th 04 03:30 PM


All times are GMT +1. The time now is 11:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"