ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/147116-worksheets.html)

Joe

Worksheets
 
Is there any way that I can create a link between worksheets? For example, my
first worksheet is a table of information. The following worksheets are an
elaboration of the information on the first worksheet, including charts,
photos, images, etc. I want to create a link such that I can click on say, a
word, and have it jump to the according worksheet with that image.

MyVeryOwnSelf

Worksheets
 
Is there any way that I can create a link between worksheets? For
example, my first worksheet is a table of information. The following
worksheets are an elaboration of the information on the first
worksheet, including charts, photos, images, etc. I want to create a
link such that I can click on say, a word, and have it jump to the
according worksheet with that image.



One way:
Insert Hyperlink Place in this document

Then put the "word" where it says "Text to display" and below that choose
the target of the link.

Gary''s Student

Worksheets
 
You need hyperlinks.

In Excel hyperlinks can be set to a web page, or another place in the
workbook. See:

http://www.mvps.org/dmcritchie/excel/navigation.htm
--
Gary''s Student - gsnu200731


"Joe" wrote:

Is there any way that I can create a link between worksheets? For example, my
first worksheet is a table of information. The following worksheets are an
elaboration of the information on the first worksheet, including charts,
photos, images, etc. I want to create a link such that I can click on say, a
word, and have it jump to the according worksheet with that image.



All times are GMT +1. The time now is 05:04 AM.

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