Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert existing Excel into Data source document to link to exist. | Excel Discussion (Misc queries) | |||
Link to password protected workbook | Excel Discussion (Misc queries) | |||
How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
link Access workbook to Excel workbook | Excel Discussion (Misc queries) | |||
Is it possible to link an Excel spreadsheet to a Word document an. | Excel Discussion (Misc queries) |