Excel Guides

How to Tie a Hyperlink to a Specific Cell in Excel

There are a few ways to tie a hyperlink to a specific cell in Excel. One way is to use the HYPERLINK function. This function can be used to create a link to another file, such as another Excel workbook, or a website. The syntax for the HYPERLINK function is as follows:

=HYPERLINK(link_location, [friendly_name])

The link_location can be either an absolute or relative path. If you are linking to another Excel workbook, the path should be enclosed in quotation marks. For example:

=HYPERLINK("C:\\Users\\John\\Documents\\Workbook1.xlsx", "Workbook1")

If you are linking to a website, the path should begin with http://. For example:

=HYPERLINK("http://www.google.com", "Google")

[friendly_name] is optional, and is what will be displayed as the link text. If this argument is omitted, the link_location will be displayed as the link text.

Note:
When using the HYPERLINK function, make sure that there are no spaces in the [friendly_name]. Otherwise, the link will not work correctly.


Another way to tie a hyperlink to a specific cell in Excel is to use an Action Hyperlink. An Action Hyperlink is an object that you can insert into a cell, and when clicked, it will perform an action such as opening a file or website.


To insert an Action Hyperlink:

1) Select the cell where you want to insert the hyperlink.
2) On the Insert tab, in the Links group, click Hyperlink.
3) In the Insert Hyperlink dialog box, do one of the following:
* To link to a file that is stored on your computer or on a network drive, click Existing File or Web Page under Link to, and then browse to and select the file.
* To link to a new document that you will create now and save later, click Create New Document under Link to.
* To link to an existing document that you will edit now and save later, click Existing Document under Linked from this location on disk (this option appears only if you have Microsoft Office Word installed).
* To link directly to a Web page without having Office open your browser first (this option appears only if Microsoft Internet Explorer 5 or later is installed), click E-mail Address under Linked from this location on disk (this option appears only if Microsoft Outlook Express 5 or later or Microsoft Outlook 2000 or later is installed).
* To link directly by e-mail address (this option appears only if Microsoft Outlook Express 5 or later or Microsoft Outlook 2000 or later is installed), click E-mail Address under Linked from this location on disk (this option appears only if Microsoft Outlook Express 5 or later or Microsoft Outlook 2000 or later is installed).
4) In Display text box, type the text that you want people who click this hyperlink to see.
5) Under ScreenTip text box type any text that you want people who position their pointer over this hyperlink see appear as a ScreenTip.
6) Click OK.

.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.