In our data in any cell if we want a user to be redirected to a web page when user clicks on it we need to insert hyperlinks on the cell, to insert a hyperlink on the cell we need to right-click on the cell and then click the hyperlink which is the last option which opens a wizard box for us to insert a hyperlink, in the box for address enter the URL for the hyperlink.
Excel Hyperlinks (Table of Contents)
How to Insert Hyperlinks in Excel
A hyperlink is a link that opens up another web page, file or section of a file when you click on it. It is a kind of shortcut created to go to a particular destination. The link can be for any web page, email address, file in your system, a section of a file or text. The type of destination file and your default settings decides which software the file will open into. Suppose you create a hyperlink for a web page, it will open up in a web browser (Internet Explorer/ Chrome/Firefox, etc.) depending upon your default web browser. If the file is a pdf file, it will open in Adobe reader if that is your default pdf reader. Creating links in Excel is very simple and commonly used. When you click a cell containing the link, Excel opens up the specified destination. In Excel, you can display any text and create a hyperlink in excel without displaying the actual destination. You can also create a hyperlink link on an image.
It is necessary to give the correct path of the destination document. The path can be to a file stored on a hard drive, a universal naming convention (UNC) path on a server (in Microsoft Excel) or a Uniform Resource Locator (URL) path on the Internet or an intranet. When you create a hyperlink, its destination is a URL, such as:
In Excel, you can insert a hyperlink, in specific chart elements or in inserted images. There are different ways to use a hyperlink. By default, the links in excel can be created by just typing in the web address. The link will be automatically created. For an illustration, just type in the web address “www.google.com”
and press Enter. You will realize that it has been automatically converted to a link in Excel.
This setting may be changed by clicking the scroll down menu in blue.
You can select “Undo Hyperlink” if you do not want a hyperlink or “Stop Automatically Creating Hyperlinks”. If you want to create links in excel automatically but it is not happening in your Excel, you can go to the AutoCorrect Options and change the setting.
Additionally, there are other ways to insert hyperlinks in Excel. You can select the text or cell where you want to insert a link in excel and press CTRL + k (or COMMAND + k for Mac). Alternatively, click on select and insert Hyperlink.
A window will pop up where you can insert a link in excel and what text to display.
Now, suppose you want to display “Google” and it will link to “http://www.google.com”. You can add Google to Display option and the web address to Link to option.
Then select OK. A link in excel will be created.
When hyperlinks are to be added iteratively, this task may become very tedious. In such cases, you may also use the Hyperlink function to do this task. Let us see how to use the hyperlink function.
How to Insert Hyperlinks using the Hyperlink Function?
Below is the hyperlink formula in excel.
Arguments used for hyperlink formula
link_location: the link to insert. Required
[friendly_name]: the jump text or numeric value to display to the link. Optional
Link_location can be a web page, a file name along with its path to open a document. It can also refer to a place, a cell in Excel or a bookmark in a document. Friendly_name can be a text string, a name, a value or a cell containing the jump text or value. If this is omitted in the Hyperlink function, the cell will display the link_location as the jump text. In case the friendly_name returns an error value, the cell will display the error instead of the jump text.
Examples of Hyperlinks
Let’ss understand the Hyperlinks in excel with examples.
To insert a hyperlink in excel of “www.google.com” with display name “Google” using the Hyperlink function in Excel, you can type
= HYPERLINK(“http://www.google.com”, “Google”)
and press Enter.
Another way to create hyperlinks in excel is to drag and drop. You can simply drag any document to the Excel sheet and drop. It will create a hyperlink in excel for that document. This strategy can be very convenient for images etc.
Suppose you have a list of URLs and their corresponding names. The data is shown as:
You are required to insert hyperlinks of these web pages and display their corresponding names as the jump text.
To do this, you can use the below hyperlink formula in excel:
= HYPERLINK (B3, A3) for the first one.
and press Enter.
You will realize that the hyperlink has been created in excel. Now, you can simply drag it to the rest of the cells.
Suppose you have the sales and revenue data for the past month for different products as shown below.
For easier lookup, you want to create a hyperlink in excel of the products- Product A, B, C, and D. The images for these products are saved as “A.png”, “B.png”, “C.png”, and “D.png” and the location of the folder is given in cell J12.
To insert hyperlinks in excel for images, you can use the Hyperlink Formula:
= HYPERLINK( ($J$12 & B5 & “.png”), “Product ” & B5)
When you press Enter, the link will be created for the image.
When you click at the link, the image will open for that product.
Now, you can drag it to the rest of the cells to create the hyperlinks in excel for the rest of the products.
Uses of Hyperlinks in Excel
You can use hyperlinks to navigate to a file or a web page on a network: internet or intranet. You can also start a file download or transfer directly by clicking at the link. create a hyperlink in excel for a file which you may want to add in the future. Hyperlinks are commonly used for email addresses. When you click on an email address, it starts to send an email to that address.
In Excel, one problem with the hyperlinks is that it automatically jumps to the hyperlink destination when you select the cell containing the hyperlink. To avoid this problem and select a cell containing a hyperlink without jumping to the hyperlink destination, you can click the cell and keep holding the mouse button until the pointer changes to a cross, then you can release the mouse button.
Sometimes in Excel, the hyperlink is created but when you click at it, it does not open the specified document. One of the reason could be that the permission to access that document of software or internet is denied. You need to change the permission settings in such cases.
Things to Remember About Hyperlinks in Excel
- The link in Excel can be created for any document on the hard drive or for any URL on the Internet or intranet
- A hyperlink can be created on any text in a cell, image or charts.
- A hyperlink can be created for any file, section of a file, email address, web page, etc.
- There are different methods to create hyperlinks in Excel. You can use the drag-drop option, or use excel shortcut CTRL + k or by using the HYPERLINK function.
This has been a guide on how to insert Hyperlinks in Excel. Here we discuss the top ways to create hyperlinks including drag and drop, excel short CTRL+k and Hyperlink Formula along with excel example and downloadable excel templates. You may also look at these useful functions in excel –