Google Answers Logo
View Question
Q: Linking within Excel ( Answered 5 out of 5 stars,   0 Comments )
Subject: Linking within Excel
Category: Computers > Software
Asked by: sharontucci-ga
List Price: $4.00
Posted: 20 Jul 2006 14:59 PDT
Expires: 19 Aug 2006 14:59 PDT
Question ID: 748123
I have an Excel question. I have a workbook with multiple sheets. I'd
like to create a table of contents so that if I click on a link, it
will switch over to the appropriate worksheet. How can I do this?
Subject: Re: Linking within Excel
Answered By: maniac-ga on 20 Jul 2006 18:19 PDT
Rated:5 out of 5 stars
Hello Sharontucci,

What you ask is straight forward using what Excel calls a "Hyperlink".

I created a sample worksheet where the first sheet has the "table of
contents" and the second & third sheet are linked from that contents
sheet. I started with a new worksheet (which defaults on my system to
three empty sheets named "Sheet1", "Sheet2", and "Sheet3".

On Sheet1, I created some descriptive labels in column A (A1 refered
to the contents, A2 to the second sheet, A3 to the third sheet).

On Sheet1, I created the hyperlinks in column B as follows:
 [1] Select menu Insert -> Hyperlink...
 [2] Select "Document" on the Insert Hyperlink window that appears and
then "Locate" near the bottom (in the area titled "Anchor").
 [3] Another window appears, requesting a cell reference. If you have
a named cell on the destination sheet, you could select it below or
enter the reference directly (e.g., Sheet2!A1) and then OK.
 [4] The reference appears at the top of the Insert Hyperlink window
and a similar value is filled in as "Display". I suggest you change
that to the phrase describing the destination sheet. Change the tool
tip if desired as well (the default tool tip is the path to your
worksheet / destination cell).
 [5] When the values are entered as desired, enter OK.
For each cell you do this to, the contents of the cell look like a
hyperlink in a web page. The cursor changes when you hover over one of
these links as well (looks like a hand on my system). Click on it to
test / take you to the other sheet.

Repeat the above steps for each cell / sheet to be linked. Adapt the
names / cell locations to fit your needs.

NOTE: If you rename the destination sheet - you have to fix the
hyperlink (at least with my version of Excel) that points to it. Use a
right click to bring up a pop up menu and use Hyperlink... again to
make the fix.

To find this information, I searched the Excel help using phrases like
  worksheet link
and after viewing the Hyperlink documentation, was able to test the
method / prepare the answer.

If a part of the answer is unclear or does not quite meet your needs -
please make a request for clarification. I would be glad to help

Good luck with your work.
sharontucci-ga rated this answer:5 out of 5 stars
Excellent assistance. Thank you.

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy