How Do I Insert Hyperlinks in Microsoft Excel?by Shelley Hoose
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.
- check When linking to a location in the same workbook, you don’t need to create a Defined Name if you just want to open another worksheet without targeting a specific cell. Just choose the worksheet name under the Cell Reference heading from the Insert Hyperlink dialog box to make the link to cell A1 of that worksheet.
- check To link to a different file or Web page, choose “Existing File or Web Page” in the Insert Hyperlink dialogue box. For a Web page, enter the full URL in the Address field below the list of files and then click "OK" to link to the site. To link to a file, browse to the file folder in the “Look in:” drop-down menu, click on the file name and click "OK" or double-click on the file name to select it. You can create a link to any file that Windows can open using an installed application, either on your computer or on any other computer you have access to through File Explorer. Windows uses your computer’s default application to open the file when you select the link.
- check You can also link to a document using the “Create New Document” button in the Insert Hyperlink dialog box. Excel prompts you to name the document, enables you to select its location and to select whether you want to add content to the new document now or later.
- photo_camera Image courtesy of Microsoft