Use Hyperlink Function/Formula Another way to manually add a table of contents in Excel is by using the Hyperlink Function.

Placing a Hyperlink into a document creates a shortcut to find related information. Microsoft Excel has several features to create a hyperlink in your worksheet.

Show users how to create a quick table of contents in Excel using the power of hyperlinks. Hyperlinks have been around for a long time, but some Excel users just don’t use them.

If you have a Microsoft Office Excel 2010 spreadsheet, you can easily create a hyperlink to a Word document and place it anywhere in the spreadsheet.