Home / MS-Excel / General Formatting

Create an Index of Sheets in Your Workbook

Using an index sheet will enable you to quickly and easily navigate throughout your workbook so that with one click of the mouse you will be taken exactly where you want to go, without fuss.

You can create an index in a few ways: by hand, auto-generated by code, or as a context-sensitive menu option.

Following these sections:

  • Auto-Generate an Index Using VBA
  • Link to the Index from a Context Menu

In this tutorial:

  1. Creating an Index Sheet by Hand
  2. Auto-Generate an Index Using VBA
  3. Link to the Index from a Context Menu