Make Table Of Contents In Excel Sheet
To create an index in your worksheet you can make use of hyperlinks. By using the hyperlink you can make it easy to navigate to a particular sheet/content in the workbook by just clicking on its link. And here’s how you can do that.
1 Make Table Of Contents In Excel Sheet1.1 Method 1: Create A Table Of Contents In Excel Using Hyperlinks1.2 Method 2: Create Index In Excel Worksheet Using VBA Code1.3 Final Thoughts
Method 1: Create A Table Of Contents In Excel Using Hyperlinks
Launch Excel on your computer and open the worksheet in which you want to create a table of content. Now, to create an index you will have to insert a new blank page to your already created worksheet. For inserting a new sheet press shift+F11, as you do that a new page will be added to your worksheet.
Now you can change the name of the sheet by clicking on it and then select Rename option from the menu
Next, select any cell on the sheet and right click on it to open the options menu. Now, select the Hyperlink option.
As you do that a new tab will open, on this tab select the option Place in This Document from the left side panel. Now select the content you want to add to the index. The selected content will highlight and the name of the content will be shown on the Text to display box at the top of the tab.
Now, remove the cell range( A1 in this case) from the content name on the Text to display box and click then on OK.
With this, the content with the hyperlink will be added to the table of content
Now you can follow steps 3, 4 and 5 to add remaining content to the table. Once created the hyperlink for all the content your index shall look something like this
Now anyone can easily navigate to all the content on your every worksheet by just clicking on the links. But, this method is not feasible for a very large worksheet because here you have to add content to the table one by one which takes a lot of time. However, there is a second method that can help you create an index for a large worksheet within seconds. ALSO READ: Convert Picture of Table Into Excel
Method 2: Create Index In Excel Worksheet Using VBA Code
VBA stands for Visual Basic for Application. Generally, coders use the VBA editor to create tools for Excel. However, you need not worry if you don’t know how to code because we are going to provide the code. You just have to copy and paste it the editor and you are good to go.
Open the Excel worksheet and press Alt + F11 to enter the VBA editor.
Now click on Insert from the toolbar at the top and select Module
Now copy and paste the following code in the module
Run the code by pressing the F5 button or by clicking on the Run button.
Next, go to Files and select Close and Return to Microsoft Excel
Now you will see the table of content is created with all the hyperlinked content all at once.
Now you can simply click on any of the hyperlinked content to explore it.
Final Thoughts
So that’s how you create a table of content list on Excel for easy navigation of a large worksheet. If you work on Excel then you should definitely learn this skill because it will keep you ahead of all. Also, if you liked our tutorial then do share this article with others as well.
