Creating a Table of Contents in Excel

In this tutorial we will look at a very simple way to create a linking system within Excel, to create a Table of Contents. So let's begin:

Tools: Microsoft Excel
Time: 10 Mins

Step 1.) Determine where you want to place your Table of Contents Header and in a cell relatively close to the top of the worksheet, enter in your title. For this example, I increased the height of Row 4, and inputed Table of Contents into the cell B4.


Step 2.) Then I decreased the width of Column B and inputted "I., II., III., etc" in the cells B8-B12. Notice that I created some space between the heading and the beginning of the number sequence, this was strictly for layout purposes.


Step 3.) Afterwards I entered the appropriate title into the cells C8-C12.
Step 4.) Then I right-clicked on the Worksheet title at the bottom of the screen and selected Rename. This can also be done by double clicking on the Worksheet title. I renamed the sheet to 'Table of Contents.'


Step 5.) Now I need to add more worksheets so I once again right-clicked on the Worksheet title at the bottom of the screen and selected Insert. Then in the Insert Window select Worksheet.


Step 6.) Once Again right-click on the worksheet title and select Rename and name it accordingly.


Step 7.) Then Drag and drop the worksheet to its appropriate location in the order of worksheets.


Step 8.) This was my finished set of worksheets.


Step 9.) Now go back to the original 'Table of Contents' worksheet and right-click on the 'Introduction' Cell. Then select 'Hyperlink.'

Step 10.) Now with the new 'Insert Hyperlink' Window open, under 'Link To' on the left, select 'Place in Document' and select Introduction and then 'OK'. You have now made a Hyperlink to the Introduction page. Test it out by clicking on Introduction and you will see that it flips to the Introduction page, indicated by the highlighted 'Introduction' Tab on the bottom of the page.


Step 11.) Complete the rest accordingly and you are finished.