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

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.

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.