Excel
Table of Contents
Generate automatic links to easily navigate your workbook or folder
How To Use Table of Contents
- Step 1: Click to the "Table of Contents" tool
- Step 2: Select "Folder Structure" or "Excel Doc"
- Step 3a: If you selected "Folder Structure" - Browse for the folder you'd like to be indexed and select "OK"
- Step 3b: If you selected "Excel Doc" - Choose from the options what you'd like indexed, which includes:
- Sheets
- Comment
- Picture
- Table
- Named Range
- Notes
- Text box
- Hyperlink
- Step 4: A new tab will appear with your table of contents with the name (TOC) consisting of names and links of preexisting sheets