close

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.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()