Log in

View Full Version : How to go to another sheet?


email2007
Mar 24, 2009, 12:02 AM
I have many worksheets within the same file, what I really want is to have either a (link / go to option) from sheet1 to other sheets without using hyperlink because I want to send to others.

Example: if I click on Apple from Sheet 1, I will go to Sheet2

JBeaucaire
Mar 24, 2009, 02:07 AM
Don't misunderstand HYPERLINKS, they are not only values to destination outside the sheet. HYPERLINKS can connect to positions within one workbook, too, which sounds like what you want.

First, insert your picture of an Apple.
Right-click the Apple and select Hyperlink
On the left panel, click on Place in Document
Enter the Cell target in "Type in the cell reference"
Double-click on Sheet2 in the "place in document" listing
Your Hyperlink is created
Deselect the apple
Click on the apple
You will go to Sheet2 to the cell indicated
This behavior will be consistent to others to whom you send this sheet. This is an 'internal" hyperlink.