Copy the Office Script code and download the featured file from this page: https://www.bluepecantraining.com/wp-content/uploads/2024/03/TOC-Office-Script.zip

In this Microsoft Excel video I tutorial I explain how to use an Office Script to automate the creation of a table of contents within a workbook. Office Scripts are available in Excel 365 (work and school versions).

If you don't have a version of Excel that supports Office Scripts see this video for a VBA macro solution: https://youtu.be/NRaouRWDG4o

00:00 Introduction
00:45 See the Office Script create the table of content
01:56 Explanation of the Office Script code
05:46 Using the Office Script in your workbook



#exceltutorial #exceltips #excel365 #excel