Excel Macro To Create Table Of Contents With All WorkSheets Names

Applications like Microsoft Word, Power Point, PDFs – all have option to create Table Of Contents. Well, Excel is an excellent tool – why shouldn’t it have a table of contents too? There are instances when you have lot many sheet in a workbook and all you need is a table of contents at the beginning for easy navigation.

Here is a ready to use Excel Macro to create table of contents of all the worksheets names. This macro creates a new worksheet as first sheet and create links to all worksheets in the workbook.

Note: To find out the detailed steps on how to create, run or edit a macro, you may refer here for excel 2003 or here for excel 2007.

Please feel free to leave your queries, feedback and suggestions in the comments section below.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">