How to Insert a Hyperlink to take you to another location in the same Workbook (Excel 2007 & 2010)
Sometimes you may want to insert hyperlinks to another worksheet inside of your workbook. In this example we are going to take a quote for supplies for a fictitious hospital. We are going to link the departments on the front page to the sheet for that department in the workbook. We are also going to insert a hyperlink on each worksheet that will take us back to the main page of the quote. This will work the same in Excel 2010 and Excel 2007.