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.

Show users how to create a quick table of contents in Excel using the power of hyperlinks.

You can use a menu command to create a hyperlink to a named range or you can use a simple drag-and-drop trick.

When you create a hyperlink for the first sheet and press Enter, all the sheet columns will automatically update with their hyperlinks. If not, you can simply drag the fill handle to apply the ...