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. |
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. |
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. |
All times are GMT +1. The time now is 05:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com