BXL Table of Contents Creator/Manager Add-in

Effortlessly add the table of contents gold standard to any Excel project.

by Craig Hatmaker
IT Executive and author of Ribbon Recipes: Beginner's Guide to Creating Excel Menus available on AmazonFollow 27

4 reviews105 views|Start the discussion!|Bookmark Add to cart - $9.99

Description
A good table of contents is a professional expectation. Adding them can be time consuming, tedious, and error prone. Keeping them updated can be a burden. And when we are finished, is all we have is a nice way to move from worksheet to worksheet? We can do better. Our table of contents can catalog all of our project's components. It can outline them so we know what belongs to what. And our table of contents can also be a great documentation source.

Catalog:
Automatically catalog all worksheets, named ranges, charts, pivots and tables in one place.

Navigate:
Automatically add links to all catalog entries so we can go to them quickly and easily, and click any worksheet's A1 cell to return.

Document:
Automatically gather documentation from worksheet titles and properties, chart titles, pivot tables, table titles and comments, name comments, cell labels, cell comments, and cell input messages.

Refresh:
Rebuild the table of contents as often as needed and never lose any changes we make manually to the table of contents.

Two-way-update:
Add titles to charts, worksheets, and tables, or comments to names, cells and tables from what we manually enter in our table of contents.

Review user's guide: https://www.dropbox.com/s/uqfpspenhy49dbm/BXL%20TOC.pdf?dl=0

This Best Practice includes
1 Excel Add-in (Windows version)