How Do I Insert Hyperlinks in Microsoft Excel?

Found This Helpful

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.

Use the Insert Hyperlink dialogue box to add a hyperlink.
(Image courtesy of Microsoft)
Step 1:

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.

Click on the text or cell that will be the target of the hyperlink.
Image courtesy of Microsoft
Step 2:

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.

Enter a name for your link in the Name box.
Image courtesy of Microsoft
Step 3:

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 your text, then open the Insert Hyperlink dialogue box.
Image courtesy of Microsoft
Step 4:

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.”

Select your Defined Name.
Image courtesy of Microsoft
Step 5:

Test the new hyperlink by clicking on it to make sure it takes you to your targeted location.

Test your new hyperlink.
Image courtesy of Microsoft

Tips & Warnings

  • 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.
  • 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.
  • 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.

References

Comments

Featured

Read Article

iPhone Screen Tips You Can Really Use