Creating a table of contents in Excel
 

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?

Creating a table of contents in Excel
 

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.

--
Gary''s Student - gsnu200772


"forest8" wrote:

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?