Are hyperlinks not opening or working in your Excel workbooks? In Excel, hyperlinks are used to open specific documents, files, folders, or web addresses saved on a network server, intranet, or web.

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.

Excel has a feature that lets you open multiple hyperlinks at once. By using this feature, you can save your time in opening the URLs one by one.

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