Excel Hyperlink Function: How to Insert Hyperlinks

In this video, on Excel Hyperlink Function, we are going to learn how to insert hyperlinks in excel sheet using Hyperlink Excel Formula.

𝐇𝐲𝐩𝐞𝐫𝐥𝐢𝐧𝐤 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥
----------------------------------------------------

Hyperlink function is an integrated Excel function that opens another page or file when you click on it. It can be text or a picture.

𝐇𝐲𝐩𝐞𝐫𝐥𝐢𝐧𝐤 𝐄𝐱𝐜𝐞𝐥 𝐅𝐨𝐫𝐦𝐮𝐥𝐚
---------------------------------------------

Below is the formula of Hyperlink Function

=HYPERLINK (link_location, [friendly_name])

𝐀𝐫𝐠𝐮𝐦𝐞𝐧𝐭𝐬
-----------------------

1. Link location - The file or page path to open.
2. Friendly name - [ optional ] Text link for cell display.

𝐒𝐭𝐞𝐩𝐬 𝐭𝐨 𝐈𝐧𝐬𝐞𝐫𝐭 𝐚 𝐇𝐲𝐩𝐞𝐫𝐥𝐢𝐧𝐤 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥
---------------------------------------------------------------

Step 1 - Select the text, cell or image you want to insert in Excel sheet a hyperlink.

Step 2 - Click Hyperlink in the Insert tab. You can also right - click the text or image and in the shortcut menu select the Excel Hyperlink option.

Step 3 - Type or paste the link in the Address box to which you want to redirect the user in the Insert Hyperlink box.

To know more about 𝐇𝐲𝐩𝐞𝐫𝐥𝐢𝐧𝐤 𝐄𝐱𝐜𝐞𝐥 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧, you can go to this 𝐥𝐢𝐧𝐤 𝐡𝐞𝐫𝐞:- https://www.wallstreetmojo.com/hyperlink-excel-function/

Subscribe to our channel to get new updated videos. Click the button above to subscribe or click on the link below to subscribe - https://www.youtube.com/channel/UChlNXSK2tC9SJ2Fhhb2kOUw?sub_confirmation=1