Creating a table of contents in Excel

F

forest8

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?
 
G

Gary''s Student

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to unlink TOC from a doc 0
Table of contents 3
EXCEL Table of Contents 1
Excel Providing user message when RED X clicked & properly closing application. 2
Refer to a worksheet/name using cell contents? 5
Getting Excel Hyperlinks to work in a PDF File 1
Creating a list / concatenate function 5
Convert Doc to PDF keeping hyperlinks & table of contents 1

Top