When your workbook only has a few sheets, you can easily navigate to them using the tabs at the bottom of Excel. But for workbooks that have lots of sheets, I recommend adding a Table of Contents as your first sheet.

Video TutorialWatch on YouTube & Subscribe to our ChannelDownloads Table of Contents Macros.xlsxDownload List-Style Table of ContentsOne format for your Table of Contents is a simple list, where each item in the list is a link that pulls you over to the corresponding sheet.

I've created a macro so that you can add this Table of Contents to any workbook in an instant. You can copy the macro from this tutorial:

Excel Table of Contents that Automatically Updates

Gallery-Style Table of ContentsA visually appealing alternative to the list-style format is a Table of Contents Gallery. This format shows screenshots from each of your worksheets. Each of the images links to its corresponding sheet so that you can jump to the sheet you want with one click.

For instructions about how to insert this type of Table of Contents into your file, check out this tutorial:

How to Add a Table of Contents Image Gallery Sheet to Your Excel Files

Help with MacrosIf you don't have much experience working with macros, check out my free 3-part video series on getting started with macros & VBA.

I hope these free tools are helpful for you and impress your boss and coworkers! If you have questions or feedback, leave a comment below.

Link to post: Table of Contents Macros