Creating a table of contents in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

forest8 - 08 Mar 2008 13:13 GMT

I have a workbook which contains 12 sheets. I want to create a table of
contents in excel that hyperlinks to each page when I select it. The first
sheet is the cover which doesn't need to be hyperlinked.

Also, I need this table of contents to still work if I PDF the file.

Is this possible?

Reply to this Message

Gary''s Student - 08 Mar 2008 14:21 GMT

Lets say your sheets are named:
alpha, beta, .....etc.

In A1 of the main sheet, enter:

=HYPERLINK("#alpha!Z100","alpha at cell Z100") to get to Z100

enter similar formulas going down the column.

Signature

Gary''s Student - gsnu200772

> I have a workbook which contains 12 sheets. I want to create a table of
> contents in excel that hyperlinks to each page when I select it. The first
[quoted text clipped - 3 lines]
>
> Is this possible?

Reply to this Message