You can add a hyperlink in Excel 2013 that takes you to a location in the same workbook, an existing file on your computer or server on your network, or to a Web page. If you are linking to a specific location in the same workbook, use Excel’s “Defined Names” feature to first identify the destination cell with a name which you then select when creating the link, much like a name anchor identifies a specific location on an HTML page. Access the Insert Hyperlink dialog box on the Insert tab in the Links group.
Click the text or cell that is the target of the hyperlink. For example, to link from an Expenses worksheet to a cell containing the text “Admissions” on an Income worksheet, click the "Income" tab to go to the target worksheet and then click the "Admissions" cell on that worksheet where you want the link to take you.
Enter a name for your link in the Name box to the left of the formula bar and then press the “Enter" key. Names cannot contain spaces and must begin with a letter. Now you are ready to set the hyperlink.
Switch to the worksheet where you want to insert the hyperlink -- for example, the Expenses worksheet in this example -- by clicking on its tab. Click on the text or cell where you want the hyperlink to appear. Select the “Insert” tab, then “Hyperlink” from the Links group to open the Insert Hyperlink dialog box. Alternatively, you can open the dialog box by right-clicking the cell and then selecting “Hyperlink” from the context menu or by using the keyboard shortcut “Ctrl-K.”
Select the “Place in This Document” button and then highlight the name you created under Defined Names -- in this example, "IncomeAdmissions" -- and then click “OK.”
Test the new hyperlink by clicking on it to make sure it takes you to your targeted location.