ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Linking text (https://www.excelbanter.com/excel-discussion-misc-queries/252423-linking-text.html)

Anne

Linking text
 
How do link (is that the right word?) from one worksheet to another? I have
a summary page and a second worksheet that gives explanations of items on the
summary page. How do I organise it so that when you click on an item on the
summary page that you are taken to the relevant item on the second worksheet?
Is that clear?

Per Jessen

Linking text
 
Hi

I think that Hyperlinks are what you need.

In the summary page, select an item, and goto Insert Hyperlink Link to:
Place in this Document Select the cell to link to.

Hopes this helps.
....
Per



"anne" skrev i meddelelsen
...
How do link (is that the right word?) from one worksheet to another? I
have
a summary page and a second worksheet that gives explanations of items on
the
summary page. How do I organise it so that when you click on an item on
the
summary page that you are taken to the relevant item on the second
worksheet?
Is that clear?



Anne

Linking text
 
Solution found - thanks Jacob!

"anne" wrote:

How do link (is that the right word?) from one worksheet to another? I have
a summary page and a second worksheet that gives explanations of items on the
summary page. How do I organise it so that when you click on an item on the
summary page that you are taken to the relevant item on the second worksheet?
Is that clear?



All times are GMT +1. The time now is 10:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com