I know how to make hyperlinks that link to websites and documents on other
drives. My question is:
Is it possible to create a hyperlink that links to another worksheet within
the SAME* workbook? Is it also possible to have the information pop up in a
new window? For example, i want to create a hyperlink in sheet1 that links to
information in sheet3 within the SAME* workbook. Then, when i click on the
link in sheet1, the reference information in sheet3 appears in a new window.
*Im not yelling. There's no option in this post for bold, so i just used
uppercase.
Hi tope12. I was able to create a hyperlink to another sheet in the same
workbook by giving the workbook name as the address and then going to
bookmark. It did not open in a new window, however. You can also specify
the cell location in the target sheet. HTH
--
Sincerely, Michael Colvinquot;tope12quot; wrote:
gt; I know how to make hyperlinks that link to websites and documents on other
gt; drives. My question is:
gt;
gt; Is it possible to create a hyperlink that links to another worksheet within
gt; the SAME* workbook? Is it also possible to have the information pop up in a
gt; new window? For example, i want to create a hyperlink in sheet1 that links to
gt; information in sheet3 within the SAME* workbook. Then, when i click on the
gt; link in sheet1, the reference information in sheet3 appears in a new window.
gt;
gt; *Im not yelling. There's no option in this post for bold, so i just used
gt; uppercase.
- Aug 07 Thu 2008 20:45
creating hyperlinks linking to other worksheets
close
全站熱搜
留言列表
發表留言