Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table of Contents Excel | Excel Discussion (Misc queries) | |||
Does Excel produce a table of contents? | Excel Discussion (Misc queries) | |||
Table of Contents for Excel File | Excel Discussion (Misc queries) | |||
Show whole Table of Contents for Excel Help | Excel Discussion (Misc queries) | |||
EXCEL Table of Contents | Excel Worksheet Functions |